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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Joe_100
Helper I
Helper I

Simple return of month name

Hi,

 

Simple question but i can't seem to get it right.
I have a table with the 12 the month names and their corresponding numbers.

MonthNameMonthnumber
Jan1
Feb2
Mar3

 

etc.

I have a slicer on monthname.
If one of the monthnames is selected i also need to return the previousmonth name in a textfield.

Started with this simple DAX but i am not sure how to return the previous month name?

Returning the previous month number works of course.

PVmonth =
VAR pvmonth1 = SELECTEDVALUE(MonthTitlesUsedInReport[MonthNumber])
VAR pvmonth = pvmonth1 -1
RETURN

???????

 

 

1 ACCEPTED SOLUTION
Joe_100
Helper I
Helper I

Solved it with a lookup value, but i guess there should be an easier way?

 

PVmonth =
VAR pvmonth1 = SELECTEDVALUE(MonthTitlesUsedInReport[MonthNumber])
VAR pvmonth = pvmonth1 -1
RETURN
LOOKUPVALUE(MonthTitlesUsedInReport[MonthName];MonthTitlesUsedInReport[MonthNumber];pvmonth)

View solution in original post

2 REPLIES 2
Joe_100
Helper I
Helper I

Solved it with a lookup value, but i guess there should be an easier way?

 

PVmonth =
VAR pvmonth1 = SELECTEDVALUE(MonthTitlesUsedInReport[MonthNumber])
VAR pvmonth = pvmonth1 -1
RETURN
LOOKUPVALUE(MonthTitlesUsedInReport[MonthName];MonthTitlesUsedInReport[MonthNumber];pvmonth)

Hi @Joe_100

There is a simple way

Measure = CALCULATE(MAX(Table1[MonthName]),FILTER(ALL(Table1),[Monthnumber]=MAX(Table1[Monthnumber])-1))

5.png

 

Best Regards

Maggie

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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