Display only the first date for status changes only

[Anonymous]

I need help with a large table that I have.

I would like to display only the following columns: ID, TAG, Team, Status and Changed Date.

However, I would like to ignore when the TAG changes (and all other changes), except for Status changes and then only get the FIRST DATE when the Status was changed.

See examples below.

BEFORE

ID	TAG	Team	Status	Changed Date
007	Good	Team A	New	01/06/2020
007	Bad	Team B	New	02/06/2020
007	Neutral	Team B	Closed	02/06/2020
007	Bad	Team B	Closed	03/06/2020

AFTER

ID	TAG	Team	Status	Changed Date
007	Good	Team A	New	01/06/2020
007	Neutral	Team B	Closed	02/06/2020

I appreciate your help in advance
Thanks

[parry2k]

@Anonymous try this measure, in the final output table, use this measure for the date and remove another changed date column

Measure x = 
VAR __m = CALCULATE ( MIN ( 'Table (4)'[Changed Date] ), ALLEXCEPT ( 'Table (4)', 'Table (4)'[ID],  'Table (4)'[Status] ) )
RETURN IF ( MAX ( 'Table (4)'[Changed Date] ) == __m, __m )

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[Anonymous]

@parry2k  thank you, but I'm geetting an error "The expression specified in the query is not a valid table expression"

[parry2k]

@Anonymous I believe you changed the table and column name in the measure per your model, correct?

[Anonymous]

@parry2k yes, I did. This is what I have:

Measure x =
VAR __m = CALCULATE ( MIN ( 'Test Scripts'[Changed Date]),
ALLEXCEPT ( 'Test Scripts', 'Test Scripts'[Work Item Id], 'Test Scripts'[State] ) )
RETURN IF ( MAX ( 'Test Scripts'[Changed Date] ) == __m, __m )

[parry2k]

@Anonymous so you are adding this as a measure, can you share the screenshot of the error. This all look ok to me.

[Anonymous]

@parry2k 
Thanks for that. I added as a measure and it worked perfectly as a measure.
However, I would like to filter by date using my slicer and unfortunately slicers can't use measures.
Is there any other way for me to do this?