Forum Discussion

Mahmed1's avatar
Mahmed1
Helper IV
3 years ago
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...
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    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's avatar
Greg_Deckler
Community Champion
3 years ago

Mahmed1 Try:

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