cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wejdan
Frequent Visitor

Calculate the previous month with Slicer

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:

Example.PNG

 

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:

Periodtable.PNG

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV
Super User IV

Re: Calculate the previous month with Slicer

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

 

View solution in original post

2 REPLIES 2
Super User IV
Super User IV

Re: Calculate the previous month with Slicer

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

 

View solution in original post

Highlighted
Pragati11 Resident Rockstar
Resident Rockstar

Re: Calculate the previous month with Slicer

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

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.