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 RequestedItemType1Type2ValueStateDate FinishedOrder
01.01.2020AAA12AB50095 100
015.01.2020AAA26AC60010001.02.2020101

 

Now I would like to determine the last state for each order where "Type1" = 6 and "Type2" = AC.

How would you build that measure?

Need Help

2 Replies

  • 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] )

     

  • stevedep's avatar
    stevedep
    Icon for Memorable Member rankMemorable Member
    5 years ago

    Hi,

    The below code should do the trick.

    ___GetLastState = 
var _maxdate = CALCULATE(MAX('Table'[Date Requested]), FILTER(ALL('Table'), 'Table'[Item] = SELECTEDVALUE('Table'[Item]) && 'Table'[Type1] = 6 && 'Table'[Type2] = "AC" ))
return
CALCULATE(MAX('Table'[State]), FILTER(ALL('Table'), 'Table'[Item] = SELECTEDVALUE('Table'[Item]) && 'Table'[Date Requested] = _maxdate))

     

    Link to the file here. 

     

    I recorded a video while creating the measure, hopefully, this helps in building an understanding of how to approach such a challenge. 

     

    Please accept as a solution if so. Thumbs up for the effort is appreciated.

     

    Kind regards, 

     

     

    Steve.