Forum Discussion

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
5 years ago

Determine Last State

Hello everyone!   I would like to determine the last tracked status within a specific systematic. So, I have this table: Date Requested Item Type1 Type2 Value State Date Finished Order ...
Need Help
CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
5 years ago

Hi, joshua1990 , you may try this measure

 

Latest Status = MAXX( FILTER(SysLog, SysLog[Type1] = 6 && SysLog[Type2] = "AC"), SysLog[State] )