Forum Discussion
MIKAOKSA
Helper I
Helper IDate filter in SUM
I need to add date filter to sum calculation. My current formula is this: AMOUNT_STOCK divided by AMOUNT_LOC_NOTAX = DIVIDE( SUM('MET_PURCHASE'[AMOUNT_STOCK]), SUM('INV_HEADER'[AMOUN...
MIKAOKSA you could try something like this:
=
VAR LastMonth_AmtStock = CALCULATE(SUM('MET_PURCHASE'[AMOUNT_STOCK]),PREVIOUSMONTH(DateTable[DateColumn]))
VAR LastYear_AmtStock = CALCULATE(SUM('INV_HEADER'[AMOUNT_LOC_NOTAX]),DATEADD(DateTable[DateColumn],-12,MONTH))RETURN DIVIDE(LastMonth_AmtStock,LastYear_AmtStock)
