Forum Discussion
Solved
Show Current Month and Previous Month Data
Hi, I have 3 measures as follows:- TotalTraining =CALCULATE (SUM (ADV_NOTE_LINES[AVL_AMOUNT]), FILTER ( ALL ( ADVICE_NOTES[AVN_TYPE] ), ADVICE_NOTES[AVN_TYPE] = "TRAINING" )) TotCredit...
smithshire Try this below DAX Measure:
MEASURE = CALCULATE([Overall], DATEADD(TableName[DateColumn],-1,MONTH))
That worked exactly as I wanted is to, many thanks.
Tahreem24
Super User
Super Usersmithshire You are most welcome! Happy to help you.