Rows where the same id had one value first and another one after that

[Anonymous]

Hi,

I am trying to output (or at least mark in an extra column) all patient IDs that have the value CD on one date and the value MR on a later date. I have been trying to figure it out but did not find a solution. Any help is welcome!

Best regards

[SpartaBI · Accepted solution]

@Anonymous here is a link to a file with a solution example I made for this question:
Rows where the same id had one value first and another one after that.pbix

      

Showcase Report – Contoso By SpartaBI

[Anonymous]

Works like a charm, thank you!

[SpartaBI]

@Anonymous my pleasure 🙂
Hey, check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas. 
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up over there if you liked it 🙂