Show the name of the month with the lowest value

[Anonymous]

Hello Dear community, 

I want to create a measure that shows the name of the month which has the lowest value. I have these values: 

AVG MONTH	Month
728	September
729	October
729	August
731	November
733	July
735	December
743	June
748	May
752	April
764	March
765	February
768	January

So I would like to have a measure that shows "September". Any ideas ?

Thanks in advance for your help.

Cheers 😄 ! 

[Anonymous · Accepted solution]

Hello,

thanks for your answer. It is still showing me the month in numbers, I will check the data formats. 

Anyways its working ! 

Cheersm

[FrankAT]

Hi @Anonymous ,

use the following measure:

Month with lowest value = 
CALCULATE (
    MIN ( 'Table'[Month] ),
    FILTER ( 'Table', 'Table'[AVG MONTH] = MIN ( 'Table'[AVG MONTH] ) )
)

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[Anonymous · Accepted solution]

Hello,

thanks for your answer. It is still showing me the month in numbers, I will check the data formats. 

Anyways its working ! 

Cheersm

[amitchandak]

@Anonymous , Try TOP N Assume AVG MONTH is measure else create a new measure

CALCULATE(max(Table[Month]),TOPN(1,allselected(Table[Month]),calculate(SUM([Total Ins]),asc),VALUES(Table[Month])))

[Anonymous]

Thanks, I got the month number (09). Is there a way to get the month name ? 

[amitchandak · Accepted solution]

@Anonymous , Use month name is this measure

CALCULATE(max(Table[Month Name]),TOPN(1,allselected(Table[Month]),calculate(SUM([Total Ins]),asc),VALUES(Table[Month Name])))