cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Highlighted
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
Highlighted
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
Community Champion
Community Champion

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



Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021