Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

How to apply a PREVIOUSMONTH measure to a standard date filter?

Hi guys, I currently have a report page that is filtered by a date column in a date table. This is currently on a slicer tool with a single select for year, month, as shown below: 

KyleAdam_0-1645915088708.png

 

And when that month is selected, all finances on that page are selected for that specific month. However, I want to make it so that it shows all finances for the previous month instead. So when I select October 2021, really it shows me the finances for September 2021. 

I know there is a DAX function called PREVIOUSMONTH:

FinanceMonth = PREVIOUSMONTH('Date'[Date].[Month]) 



But I'm not sure how to apply it in this context. I've tried creating the PREVIOUSMONTH with this current date column and date table but it won't allow me to add it to the slicer. Is there any suggestions or help on how I've went wrong and how to rectify this problem? 

 

 

 

 

 

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

Syndicated - Outbound

Hi,

It will work like this

=calculate([Totalsales],previousmonth(calendar[date]))

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

4 REPLIES 4
jianlong
Resolver I
Resolver I

Syndicated - Outbound

Here is a sreenshot for your reference:
1) create a table with current month and previous month.   "Previousmonth" can be used to create Prev column,

2) create relationship between the date/month in your finance table, and "Prev" month..

 

Hope this help. 

jianlong_0-1645923476099.png

 

Ashish_Mathur
Super User
Super User

Syndicated - Outbound

Hi,

It will work like this

=calculate([Totalsales],previousmonth(calendar[date]))

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
avatar user
Anonymous
Not applicable

Syndicated - Outbound

Hi @Ashish_Mathur thank you, it does involve creating a of measures this way because I have several finance data that is being displayed, but it still works so thank you. 

Syndicated - Outbound

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)