1 Period moving average - non std calendar


#1

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


Cumulative Sales TD (non std calendar)
#2

Going on your other question, I truly believe you need to setup a normal calendar and then add the appropriate financial years and periods to it.

You will really find it difficult to complete any time intelligence in Power BI without one.

Here’s are some videos to review