Forum Discussion
Quick comparison of values on same table
You might find my recent article useful https://exceleratorbi.com.au/finding-the-date-of-the-next-record-in-power-query/
I was solving a different problem but the structure of the problem is the same, ie how to match records on different rows and capture the dates. My only different advice would be to sort by NDC then Date as the first step.
Community ChampionYou might find my recent article useful https://exceleratorbi.com.au/finding-the-date-of-the-next-record-in-power-query/
I was solving a different problem but the structure of the problem is the same, ie how to match records on different rows and capture the dates. My only different advice would be to sort by NDC then Date as the first step.
I sure will!
I would also ask you to sign your book Supercharge Power BI: Power BI is Better When You Learn To Write DAX, but I have the kindle version. It was great and I use it a lot.
I'll update when I try it out.
Thank you!