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

i am new to this, didt see old messages, out of enthusiasm I gave my suggestion thinking I replied first. Thanks for pinning . You nailed it😀

littlemojopuppy's avatar
littlemojopuppy
Icon for Community Champion rankCommunity Champion
4 years ago

Right 🤣

We're going to let you nail your first solution noob!  Congrats!