Forecast to Actuals formula

@SamSPAIN

Please adhere to forum guidelines. Know that asking more than one question in any forum thread or asking question after question in the same forum thread around the same project or piece of development work is considered to be inappropriate.

a) Look into anything relating Virtual tables and the Time Intelligence Series Brian an I did because we also covered using Date table Offsets…

b) I would expect so. Think of how you want that figure to be allocated and use the Offsets in your date table to divide and project that figure forward over multiple Q.

c) the Model is what drives every analysis / DAX calculation, if you expect there is a problem. Stop, Investigate and Fix before you move on.

d) I’m not entirely sure what you mean by that but snapshots usually need to be exported to be preserved.
.

I can relate to the fact that there will always be more questions, I know I have many :wink: but if your initial question has been answered please mark the thread as solved. You can always create a new thread if further assistance is required down the line.