Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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...
Dashboards
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Team,

 

We need to open PBIX File then hope we understand better as Average for 4 Quarter not working few yellow highlighed periods in the measure.

 

I've uploaded PBIX File into Google Drive and don't know how to share the file other way.

 

Thanks!