Forum Discussion

SamOvermars's avatar
SamOvermars
Icon for Helper I rankHelper I
4 years ago
Solved

Compare data with previous last month not working

Hello, I have this dax used for the Lst Month column LastMonth= CALCULATE( SUM( table1[cost]), DATEADD( table1[date], -1 , MONTH ))   but its showing blank as you see. I created a new cale...
Need Help
  • littlemojopuppy's avatar
    littlemojopuppy
    4 years ago

    Hi SamOvermars 

    Try this instead

    LastMonth = 
CALCULATE(
	SUM( table1[cost]), 
	PREVIOUSMONTH(DateTable[DateField])
)
saravanan_p's avatar
saravanan_p
Icon for Resolver III rankResolver III
4 years ago

share your file to fix it.