Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Charline_74
Helper III
Helper III

How to display the latest status of each WorkItemID

My data : 

Charline_74_1-1685345468797.png

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.

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

vbinbinyumsft_0-1685513921191.png

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.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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

vbinbinyumsft_0-1685513921191.png

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
Super User
Super User

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.