Forum Discussion

harirao's avatar
harirao
Post Prodigy
6 years ago

Four weeks sliding average

Hi All,

 

 

Looking for suggestions/help. I have to created % measure column by using two separate measures for weekly metric, now need to create another column as four week sliding average. 
Condition is “N/A” to be ignored, should consider only earlier week which is having numbers as well as 0% to be included for Average Calculation.
required an average over the last four available weekly results. 

 

Existing Column for weekly reporting

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Below example for reference

If I am selecting current week i.e 11/11/2019

Avg for WW:

11%+20%+34%+33%= 97% !! Avg will be (97%/4)=24%

where as Avg for Latin America should be:

50%+100%+0%+N/A+N/A+33%=183%!! Avg should be (183%/4)=45.75%

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Thanks & Regards,

 

Need Help

1 Reply

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    6 years ago

    Hi harirao,

     

    You can try to remove "N/A" and select the top four values to calculate the average and set the expression of filter.

     

    Best Regards,

    Liang 

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.