Cumulative Sales TD (non std calendar)

[sam.mckay]

Please refer to your other forum threads.

This all comes down to getting a proper date table into your model.

1 Period moving average - non std calendar

The Moving average in the course uses the AVERAGEX ( DATESINPERIOD (Dates(Date), LASTDATE ( Dates[Date] ), -1, MONTH ), [Sales LQ] What would the formula be to calculate this based on a fiscal period number in a non std calendar

Financial templates vsLastYear make sameperiod

Thanks. I have the financial template working with my calendar using the formula I mentioned in my original post: CALCULATE([Total Sales],FILTER(ALL(‘544 Calendar’),‘544 Calendar’[MthnNumber] >=MIN(‘544 Calendar’[MthnNumber])-10000 && ‘544 Calendar’[MthnNumber] <=MAX(‘544 Calendar’[MthnNumber])-10000)) What I can’t work out how to do is when there is no data for the current year how to make it not show a difference when having the vsLastYear option checked. I notice that the model on the we…