Show Current Month and Previous Month Data

[smithshire]

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 =CALCULATE (SUM (HIL[IVL_CHARGE]),

FILTER ( ALL ( HI[IVC_INVOICE_TYPE] ), HI[IVC_INVOICE_TYPE] = "CREDIT" ))

TotHire =CALCULATE (SUM (HIL[IVL_CHARGE]),

FILTER ( ALL ( HI[IVC_INVOICE_TYPE] ), HI[IVC_INVOICE_TYPE] <> "CREDIT" ))

Which I use to calculate the overall spend of a customer in another measure:-

Overall =[TotHire]+[TotalTraining]-[TotCredit]

I have a calendar table.

I can display the monthly totals for each customer using a month/year date slicer:-

How can I also display the the previous month total based on the slicer selection for each customer?

[smithshire]

That worked exactly as I wanted is to, many thanks.

[Tahreem24]

@smithshire You are most welcome! Happy to help you.

[Tahreem24 · Accepted solution]

@smithshire Try this below DAX Measure:

MEASURE = CALCULATE([Overall], DATEADD(TableName[DateColumn],-1,MONTH))