Forum Discussion
Numbering occurrences
Hey, I'm stuck in one problem that i can't come with the proper solution. I want to number in a collumn "Occurrence", the occurrences from collumn "ID". I need to number them as they appear, not count how many times they happen. Something like the below:
I appreaciate your help!
2 Replies
Do you want the solution in Power Query or in DAX? If in DAX, can it be a calculated column or does it need to be a measure?
yes, i forgot to mention, it'd be perfect to have it as a calculated column!
