cancel
Showing results for
Did you mean:
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:

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:

1 ACCEPTED SOLUTION

Accepted Solutions
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.

2 REPLIES 2
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.

Highlighted
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

Announcements

#### Announcing the New Spanish Forum

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

#### MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

#### ‘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.

Top Solution Authors
Top Kudoed Authors