Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I need to calculate the rolling average of the data for period of 12 months. How can i do that? Please help.
This has been covered pretty well by Alberto, who is a whiz in this sort of stuff.
A pretty complicated set of steps, but if you follow them, you should be good
Rolling 12 Months Average in DAX - SQLBI
If this helped, give this comment a thumbs up so that others know if this is the solution
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |