previous month Revenue to the Current month_09152023.pbix
get last month value in customized number sort
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