topic Re: Find max date in DAX Commands and Tips

Find max date

Mahmed1 — Tue, 28 Feb 2023 22:45:53 GMT

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

Re: Find max date

Greg_Deckler — Tue, 28 Feb 2023 23:14:19 GMT

Mahmed1 Try:

max_val_date = VAR __maxVal = [max_val] VAR __Table = FILTER(ALL('dimtable'), [%Handled] = __maxVal) VAR __Result = MAXX(__Table,[date]) RETURN __Result

Re: Find max date

Mahmed1 — Tue, 28 Feb 2023 23:52:40 GMT

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