Four weeks sliding average

[harirao]

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,

[V-lianl-msft]

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.