How to get my power bi to record the date of a value change?

[Anonymous]

Hi guys!

I have a collumn pulling yesterdays status per ID e.g 'Red' 'Amber' or Green and I have a collumn of todays status. I want my power bi to record the date of change to green if possible. End goal is to create a decreasing glidepath of deliverables outstanding (goal to get deliverables outstanding count to 0 / all Green.

E.g:

Deliverable ID | Yesterdays Status | Todays Staus | Change? | Date of Change

1 | Green | Green | False

2 | Amber | Green | True

3 | Red | Amber | False

[Anonymous]

Hi @Anonymous ，

According to your provided table info, the raw data doesn't have any date field in it, what is the logic of the date of change to green you mentioned? If [Todays Status] is green and has a different status than [Yesterday Status], the date of change to green will be updated as Today()? Or is there some other backend logic? Also, are you trying to get a count of changes to green for per date? Please share the related information, later we will provide you a suitable solution base on your shared information.Thank you.

Best Regards

[Anonymous]

This is the goal ( this is excel) we want this in power bi but to get that I'll need a count of the deliverables outstanding and the dates that they've changed to green.