previous month Revenue to the Current month_09152023.pbix

Goal

get last month value in customized number sort

Solution

Previous Month Revenue = 
VAR CurrentMonth = MAX('MonthMappingTable'[MonthNumber])
VAR PreviousMont=
    CALCULATE(
        MAX('MonthMappingTable'[MonthNumber]),
        FILTER(ALL('MonthMappingTable'), 'MonthMappingTable'[MonthNumber] < CurrentMonth)
    )
VAR PreviousMonthRevenue =
    CALCULATE(
        SUM('Core Event Reason List'[Revenue]), 
        ALL(MonthMappingTable[Fiscal Month]), MonthMappingTable[MonthNumber] = PreviousMont)
    
RETURN PreviousMonthRevenue