Forum Discussion
Conditional/Calculated Column for Sequencing
I have a dataset that contains annual upload information from users who use the same ID for every upload. I would like to create a conditional column (or maybe it is a calculated column?) that provid...
There are already some good answers to this out there. I'd recommend, for example, RADACAD
https://radacad.com/create-row-number-for-each-group-in-power-bi-using-power-query
Apologies about the table format, I don't know what happened. There are two columns, ID and Reporting Period Start Date in the first example and three columns, ID, Reporting Period Start Date, Reporting Year in the second