Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Mariusz
Community Champion
Community Champion

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
Pragati11
Super User
Super User

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Mariusz
Community Champion
Community Champion

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

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors