Forum Discussion

ConnorH's avatar
ConnorH
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago
Solved

Lead and Lag Help

I am getting really close to solvbing my issue but there is just one more peice I can not figure out. I was able to pull the Latest date where ProjectID=ProjectID and Status=Status. I still do not kn...
Dax Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    6 years ago
    Last status date =
var _ProjectID = 'Status'[ProjectID]
var _Status = 'Status'[Status Extract]
Var _StatusDate = 'Status'[Modified]
var _LaterDate = MAXX(FILTER('Status','Status'[ProjectID] = _ProjectID && 'Status'[Status Extract] = _Status), 'Status'[Modified])

Return IF(_LaterDate=_StatusDate,_LaterDate)
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

ConnorH , Try a new column like

maxx(filter(Table, [ProjectID] =earlier([ProjectID]) && [Status Extract] =earlier([Status Extract])),[Modified] )