Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I'm trying to calculate the moving 3 month avearge percentage.
Below is the table screenshort and the dax calculations I used.
How do I add additional dax to calculkate the moving 3 month %Worse average, so for November it will be 0.45%,(0.48+0.35+0.52)/3 , October 0.44% ,(0.49+0.48+0.35)/3, and so on.
The Dateid column is in the same table and only has month end dates and formatted to date/time.
Thank you
Thank you.
It worked for values. But when I tried to create the same view for volumes, the output is the same for all the dates.
Hi @nv1950 ,
You can use "DATESINPERIOD" function to return the rolling 3 months.
filterDate = DATESINPERIOD ( 'Date'[Date], LastCurrentDate, - NumOfMonths, MONTH )
Then use CALCULATE function and AVERAGEx function and you can reference the following document.
Rolling 12 Months Average in DAX - SQLBI
Best Regards,
Community Support Team _ xiaosun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Do you know why my rolling avearge values are the same?
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.