Forum Discussion
alicemolk
3 years agoFrequent Visitor
Average 6 months
Hello everyone,
How can I write the DAX to get the average number of 6 months by slicer?
EX: Slicer is 4/2022 - 11/2022 so the average is number from 5/2022-11/2022
(the yellow line)
Thank you.
1 Reply
- AnonymousNot applicable
Hi alicemolk ,
You could refer the solution in this post to get rolling 6 month's average.
Solved: Rolling 6 Month Average (new column) - Microsoft Power BI Community
Best Regards,
Jay