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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Praneeth19
Frequent Visitor

Switch between Last one month and custom date range

Hi, I am having a lage date rage for example lets say i have 10 years of date range but when i open a report in power bi service the report must show the date rage of last one month but i must also be able to customize the date a required and I must not use the relative Date slicer if any one know the solution can you please let me know?

 

2 REPLIES 2
amitchandak
Super User
Super User

@Praneeth19 , based on what I got you need a column like this in you table

 

Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1*month(Today())),"Last year Last Month" ,
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)

 

and save on last month

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

what do i do after creating the new column how do i switch between the latest month and custon date slicer?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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