Numbering occurrences

[brugliatof]

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!

[lbendlin]

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?

[brugliatof]

yes, i forgot to mention, it'd be perfect to have it as a calculated column!