Calculate the previous month with Slicer

[wejdan]

Hi,

I have a table with revenue records and I'm using the slicer to filter this table, the slicer records contain the period month like this: (Jan 18, Feb18  ...Dec19).

I need to bring the same revenue records for the previous month on the same table. As Follow:

I've tried to write the below measure for the previous month column, but it’s not returning any records:

Measure = var x = ‘Periods’ [Period Num]

return  CALCULATE (‘Revenue’[Amount], ‘Periods’[Period Num]=x-1 )

The Periods table is as follow:

[Pragati11]

Hi @wejdan ,

If you are looking for a caluclation for Previous timeperiod based on the timeperiod selected in your slicer, refer PREVIOUSMONTH DAX functions:

https://docs.microsoft.com/en-us/dax/previousmonth-function-dax

You can also check for similar Time Intelligence DAX functions.

https://docs.microsoft.com/en-us/dax/

Thanks,

Pragati

[Mariusz · Accepted solution]

Hi @wejdan 

You might find this Blog Post helpful.

https://community.powerbi.com/t5/Community-Blog/Relative-Date-Dimension/ba-p/779039

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn