Forum Discussion
Solved
Find max date
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
Mahmed1 Try:
max_val_date = VAR __maxVal = [max_val] VAR __Table = FILTER(ALL('dimtable'), [%Handled] = __maxVal) VAR __Result = MAXX(__Table,[date]) RETURN __Result
2 Replies
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
