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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
adi_dasturkar
Regular Visitor

How to get previous month name on the card when I select any particular month from slicer.

Selected Month = SELECTEDVALUE('Date'[Date].[Month])

The above expression returns the current month selected by the slicer in a card as dynamic text. ex. If a user selects December it will change the text to display December.

 

But I want previous month eg. when user select January it should display December. 

 

Please help me. 

Thanks in advance!

2 REPLIES 2
Amrselim89
Frequent Visitor

MonthShift = SWITCH(
SELECTEDVALUE('Date'[Date].[Month]),"December","November","November","October","October","September","September","August","August","July","July","June","June","May","May","April","April","March","March","February","February","January","January","December")
 
sir please i solve you error, please give okay and thumps up.
domagajack
Regular Visitor

It's not going to be what you're looking for exactly, but I operate on functions like below regarding formatting and editing dates.

 

FORMAT(DATE(YEAR(SELECTEDVALUE('Date'[Date])),MONTH(SELECTEDVALUE('Date'[Date]))-1,DAY(SELECTEDVALUE('Date'[Date]))),"MMMM")
 
I'm new here and unsure of that solution, hope it helps though.
 
Best,
Jacek

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.