Forum Discussion

brekeke's avatar
brekeke
Frequent Visitor
8 years ago
Solved

Moving Average of Calculated Percentage Measure

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 arti...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    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] )
    )
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

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's avatar
brekeke
Frequent Visitor
8 years ago

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