Forum Discussion

ManuApo's avatar
ManuApo
Icon for Helper II rankHelper II
3 years ago

Struggling to create Measure :( Please help!!

Hi community,  I am really struggling to create a measure that basically shows the StatusID every day in a date calendar until it changes. My dataset has some IDs with different StatusID that chan...
DAX
Measures
tricks and tips
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

ManuApo Try this:

Measure = 
  VAR __Date = MAX('Calendar'[Date])
  VAR __ID = MAX('Facts'[ID])
  VAR __Last = MAXX(FILTER(ALL('Facts'),[ID] = __ID && [Date]<= __Date),[Date])
  VAR __Result = MAXX(FILTER(ALL('Facts'),[ID] = __ID && [Date] = __Last),[Status])
RETURN
  __Result