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

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

adi_dasturkar — Wed, 08 Jul 2020 11:00:29 GMT

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!

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

domagajack — Thu, 09 Jul 2020 01:50:52 GMT

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

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

Amrselim89 — Sun, 21 Aug 2022 12:40:27 GMT

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.