https://community.fabric.microsoft.com/t5/Developer/Numbering-occurrences/m-p/1565389#M26846 <P>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?</P> Tue, 22 Dec 2020 14:37:04 GMT lbendlin 2020-12-22T14:37:04Z https://community.fabric.microsoft.com/t5/Developer/Numbering-occurrences/m-p/1549856#M26766 <P>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:&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2020-12-14 at 17.35.29.png" style="width: 414px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/416407i52B2129EDCA31327/image-size/large?v=v2&amp;px=999" role="button" title="Screen Shot 2020-12-14 at 17.35.29.png" alt="Screen Shot 2020-12-14 at 17.35.29.png" /></span></P><P>I appreaciate your help!</P><P>&nbsp;</P> Mon, 14 Dec 2020 20:40:07 GMT https://community.fabric.microsoft.com/t5/Developer/Numbering-occurrences/m-p/1549856#M26766 brugliatof 2020-12-14T20:40:07Z https://community.fabric.microsoft.com/t5/Developer/Numbering-occurrences/m-p/1565389#M26846 <P>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?</P> Tue, 22 Dec 2020 14:37:04 GMT https://community.fabric.microsoft.com/t5/Developer/Numbering-occurrences/m-p/1565389#M26846 lbendlin 2020-12-22T14:37:04Z https://community.fabric.microsoft.com/t5/Developer/Numbering-occurrences/m-p/1573479#M26935 <P>yes, i forgot to mention, it'd be perfect to have it as a calculated column!&nbsp;</P> Tue, 29 Dec 2020 14:02:35 GMT https://community.fabric.microsoft.com/t5/Developer/Numbering-occurrences/m-p/1573479#M26935 brugliatof 2020-12-29T14:02:35Z