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)
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
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)