How to display the latest status of each WorkItemID

[Charline_74]

My data : 

I would like to display the latest status for each WorkItemID.

But I don't really understand how to do it,
I've tried filtering with the date, but if the most recent date is 28/02/2023, the WorkItemID is not displayed.

[v-binbinyu-msft · Accepted solution]

Hi @Charline_74 ,

Please try below steps:

1. create a measure with below dax formula

Latest Status =
VAR _id =
    SELECTEDVALUE ( 'Table'[WorkItemId] )
VAR tmp =
    FILTER ( ALL ( 'Table' ), [WorkItemId] = _id )
VAR max_date =
    MAXX ( tmp, [Date.1] )
VAR _val =
    CALCULATE (
        MAX ( 'Table'[Dernier State US] ),
        FILTER ( tmp, [Date.1] = max_date )
    )
RETURN
    _val

2. add a table visual with field and measure

Please refer the attached .pbix file

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Idrissshatila]

Hello @Charline_74 ,

Try to make a new measure that displays Max date and put it alogside the workItemId and it should display the max date for each ID.

MaxDate = MAX(<column>)

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin