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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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