Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
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
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
Thank you, it works well with minor changes since it was supposed to be split!
Kind regards,
Jari
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
12 | |
11 | |
7 | |
6 |