How to display max month name selection and min month name selection from slicer?

[Anonymous]

Hi,

I have kept the Month name in the slicer.

Jan
Feb
March
April
May
June
July
August
September
October
November
December

Based on user selection I need to display Max Month name and Min Month name selection in visual. Example: If the user chooses March, April, May, and October. I need to display March and October in visuals. How can we achieve this?

[SPGMat]

Syntax is incorrect:

measure =

var _max  = maxx(allselected(table),table[Sequence])

return

maxx(filter(table, table[Sequence]=_max),table[Month])

[Tahreem24 · Accepted solution]

@Anonymous ,

YOu can see the result in below screen shot for both Min and Max column.

MaxSelectedMonth =

VAR maxselected =

CALCULATE (

MAX ( Sheet1[Date1] )

)

RETURN

IF ( ISFILTERED ( Sheet1[Date1] ), maxselected )

MinMonth =

VAR minselected =CALCULATE (MIN(Sheet1[Date1]))

Return if(ISFILTERED(Sheet1[Date1]),minselected)

Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.

[aakif_aslam]

I've a similar requirement where I need to filter the amount based on the MaxSelectedMonth.

Can you help me ?

[Anonymous]

Thanks for your response.

If I created the same in my power bi it is displaying a blank data even I selected in the slicer.  If I select Jan, Feb, and March it needs to display Jan but it is displaying blank value.

DAX: 

MaxSelectedMonth =

VAR Maxselected = CALCULATE(MAX('Date'[MonthNameLong]))

RETURN IF (ISFILTERED('Date'[MonthNameLong]),Maxselected)

[Tahreem24]

@Anonymous ,

I test below DAX and it is working fine for MAX month:

Max_Month =

VAR max_=

CALCULATE (

MAX ( Sheet1[Month] )

)

RETURN

IF ( ISFILTERED ( Sheet1[Month] ), max_ )

And for Min Month just replace MAX with MIN.

Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.

[amitchandak]

You need to create a month sequence .

The use that.

measure =

var _max  = maxx(allselected(table),table[Sequence])

return

maxx(filter(table[Sequence]=_max),table[Month])