Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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 @Anonymous ,
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 April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
100 | |
65 | |
44 | |
36 | |
36 |