Forum Discussion
4Q Rolling Average (Cumulative Average) Include 0 value
Dear Team - I am trying to calculate each four Quarter Rolling Average which include 0 value as my formulas does not works well. Its excluding zero value and calculate measure. But i need to inc...
Hi Anonymous ,
Please do this in the power query, as the measure is not an actual column of data and is only calculated when used.
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi Scott - I tried power Query first to fix this as different came out then we developed in Measure to get a solution.