Moving Average of Calculated Percentage Measure

[brekeke]

Hi All,

I'm looking for a solution for the problem below.

Previously, @v-jiascu-msft had a good solution for quite the same challenge here but I realized that my question was a bit poorly articulated.

So here it is again, with a twist:

I'm looking for the moving average of the highlighted facts. The problem is that I need to derive the moving average from percentages.

Please find the sample file at this link: https://www.dropbox.com/s/tntayh3i1w0d3jy/moving_average_dummy_v0.2.pbix?dl=0

And data at this one: https://www.dropbox.com/s/0y7ms7zap07gash/moving_average_dummy.xlsm?dl=0

Thanks,

breki

[Greg_Deckler]

I would think that if you combine these two techniques:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Rolling-Average/m-p/160720

https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

That should get you there.

[Zubair_Muhammad · Accepted solution]

@brekeke

This MEASURE hopefully will get you the desired results except for 2016_W03

Moving Average=
VAR Top3weeks =
    TOPN (
        3,
        CALCULATETABLE (
            VALUES ( tbl_periods_all[Period Column] ),
            FILTER (
                ALL ( tbl_periods_all ),
                tbl_periods_all[WeekNum] <= SELECTEDVALUE ( tbl_periods_all[WeekNum] )
                    && YEAR ( tbl_periods_all[Start Of Period] )
                        = YEAR ( SELECTEDVALUE ( tbl_periods_all[Start Of Period] ) )
            )
        ),
        CALCULATE ( SELECTEDVALUE ( tbl_periods_all[WeekNum] ) ), DESC
    )
RETURN
    IF (
        COUNTROWS ( Top3weeks ) = 3,
        AVERAGEX ( Top3weeks, [Cat_1 + Cat_2 % of Total] )
    )

[brekeke]

@Zubair_Muhammad, this looks good and worked as well with some modifications. Thank you!

[Zubair_Muhammad]

@brekeke