Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have an original table using which I need to calculate the rolling average of rating table. However I do not get the expected output. Can somebody please help me with a DAX solution for this ?
Please refer the image below:
Any help would be appreciated !
Solved! Go to Solution.
Hi @ketan10
Try this MEASURE
Rolling 2 Days Average = AVERAGEX ( TOPN ( 2, FILTER ( ALL ( TableName[Date] ), TableName[Date] <= SELECTEDVALUE ( TableName[Date] ) ), TableName[Date], DESC ), CALCULATE ( AVERAGE ( TableName[Rating] ) ) )
I replicated your data and chose Average of Rating instead of Sum or Don't summarize etc..
Hi @ketan10
Try this MEASURE
Rolling 2 Days Average = AVERAGEX ( TOPN ( 2, FILTER ( ALL ( TableName[Date] ), TableName[Date] <= SELECTEDVALUE ( TableName[Date] ) ), TableName[Date], DESC ), CALCULATE ( AVERAGE ( TableName[Rating] ) ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |