Calculate Run Rate

Hi Anonymous ,

Here I create a sample to have a test. I suggest you to create a Calendar table to help your calculation.

Calendar = ADDCOLUMNS(CALENDARAUTO(),"Year",YEAR([Date]),"Month",MONTH([Date]),"MonthShortName",FORMAT([Date],"MMM"))

Data model:

Measure:

Net Sales = CALCULATE(sum('Table'[Value]))

Running Rate = 
VAR _LASTMONTH =
    CALCULATE (
        MAX ( Calendar[Month] ),
        FILTER (
            ALL ( 'Calendar' ),
            'Calendar'[Year] = MAX ( 'Calendar'[Year] )
                && [Net Sales] <> 0
        )
    )
VAR _Total =
    CALCULATE ( [Net Sales], ALLEXCEPT ( 'Calendar', 'Calendar'[Year] ) )
RETURN
    DIVIDE ( _Total, _LASTMONTH ) * 12

Result is as below.

Best Regards,
Rico Zhou

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