Forum Discussion
Return a value depending on a max value in another column
Hi,
I am looking at some data regarding earthquakes. I can return the highest Magnitude for the selections made, e.g. 8,2 in magnitude. What I want is to also retrieve the date for when it happened, and the region. So, if I select the month of July and the highest recorded magnitude was outside Japan on 2021-08-12, how can I get that value on a card? Looks like I am not using the correct DAX! Data looks as in the image below, thanks!
Kind regards,
Jari
Hi,
Date/Region Highest Magnitude = VAR MyTable = ADDCOLUMNS ( 'Table 1', "Concat", 'Table 1'[Date] & "|" & 'Table 1'[Region Name] ) RETURN MAXX ( MyTable, IF ( 'Table 1'[Magnitude] = MAX ( 'Table 1'[Magnitude] ), [Concat] ) )Regards
2 Replies
- Jos_Woolley
Solution Sage
Hi,
Date/Region Highest Magnitude = VAR MyTable = ADDCOLUMNS ( 'Table 1', "Concat", 'Table 1'[Date] & "|" & 'Table 1'[Region Name] ) RETURN MAXX ( MyTable, IF ( 'Table 1'[Magnitude] = MAX ( 'Table 1'[Magnitude] ), [Concat] ) )Regards