Forum Discussion

Shreeram04's avatar
Shreeram04
Icon for Resolver III rankResolver III
4 years ago

Display Month Name

Hi All,   I want to display the month name on a card that has the largest value in the year. For example, January has a value of 20, Feb has 40 and march has 50 means I want to display march(Month ...
Need Help
Show and Tell
Tips and Tricks
PC2790's avatar
PC2790
Icon for Community Champion rankCommunity Champion
4 years ago

Hey Shreeram04 ,

 

Try this:

MaxValueMonth = FIRSTNONBLANK(TOPN(1,VALUES(Table[MonthName]),[measuretogetthemaxvalue]),1)