Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Help: what is the Dax code To use????

Hi Newbie here in Dax formula,    what formula should i use if this is the outcome that i want to see ( expected Result, i want to get the oldest date). Thank you so much for the help   Profil...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

Anonymous As a column:

expected Result column = 
  VAR __ProfileId = [ProfileId]
  VAR __MinDate = MINX(FILTER('Table', [ProfileId] = __ProfileId), [Final Submission Date])
  VAR __Result = MINX(FILTER('Table', [ProfileId] = __ProfileId && [Final Submission Date] = __MinDate), [DistinctProfileDate])
RETURN
  __Result