Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All
Hoping you can help me
please
i have some a dax code that give me the maxx code which i put in a card
max_val = maxx(dimtable[date],[%Handled])
i neee to also get the date the max_val is but cant seem to figure out how i get the corresponding date
Solved! Go to Solution.
@Mahmed1 Try:
max_val_date =
VAR __maxVal = [max_val]
VAR __Table = FILTER(ALL('dimtable'), [%Handled] = __maxVal)
VAR __Result = MAXX(__Table,[date])
RETURN
__Result
@Greg_Deckler Thank you - ill give that a go
i was trying to find a way of getting a table from selected visual
thank you once again
@Mahmed1 Try:
max_val_date =
VAR __maxVal = [max_val]
VAR __Table = FILTER(ALL('dimtable'), [%Handled] = __maxVal)
VAR __Result = MAXX(__Table,[date])
RETURN
__Result
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |