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))
Tahreem24
Super User
Super Usersmithshire Try this below DAX Measure:
MEASURE = CALCULATE([Overall], DATEADD(TableName[DateColumn],-1,MONTH))