Highest previous value

Hi Anonymous 

Please try the following Measure.

higest previous order mth =

VAR midT =

    TOPN (

        1,

        FILTER (

            SUMMARIZE (

                ALL ( DimTable ),

                DimTable[Month],

                DimTable[MonthYearNumber],

                "val", SUMX ( DimTable, [#Orders] )

            ),

            DimTable[MonthYearNumber] <= MIN ( DimTable[MonthYearNumber] )

        ),

        [val], DESC

    )

return MAXX ( midT, [val] )

Then, the result should look like this.

For more details, please refer to the attached pbix file.

Best Regards,

Community Support Team _ Caiyun

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!