Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Moving Monthly average

Hi, trying to compute the monthle moving average of sales. In my case i have merged two table in the QueryEditor, both fact tables. Table 1: Containing the facts on invoice number level, and; T...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

Anonymous , make sure year and month are coming from date table. Measure is correct, try like

 

CALCULATE(
AVERAGEX(
VALUES('Date Table'[Year-Month]);
AVERAGE([Projectmutaties.Verkoop-bedrag])
);DATESINPERIOD('Date Table'[Date]; LastSelectedDate; -NumOfMonths; MONTH ) )

 

Join with date table should be single directional

 

It can be because any of the 5 reason

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4