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

[adi_dasturkar]

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!

[Amrselim89]

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]

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