Find max date

[Mahmed1]

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]

@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

[Greg_Deckler · Accepted solution]

@Mahmed1 Try:

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