Custom column index based on Group

[Anonymous]

Hi, 

We are trying to create a custom index for comment field with respect associated number field. Unfortunately we do not have any date fields to condition. Below the data and expected output we are trying to. 

Number	Comment Field
3003	Comment
3003	Comment
3004	Comment
3004	Comment
3004	Comment

And we are trying to achieve lie below

Number	Comment Field	Index
3003	Comment	1
3003	Comment	2
3004	Comment	1
3004	Comment	2
3004	Comment	3

Background : Originally the comment foekd is coming from third party application as Rich Text form, and we are building report in Report Builder using Power Bi model as source. So in report builder if I create a table and add row number is it getting displaying as below .  We tried different options but because of the rich text the row number indent is not aligning. 

[sevenhills · Accepted solution]

Not clear whether you are planning to do in DAX, M Query or Report Builder

Dax:

https://datacornering.com/create-group-index-column-by-using-dax/

M Query:

https://radacad.com/create-row-number-for-each-group-in-power-bi-using-power-query 

Report builder / paginated report (same as ssrs):

https://docs.microsoft.com/en-us/sql/reporting-services/lesson-6-adding-grouping-and-totals-reportin...

https://www.dotnetspider.com/resources/45773-grouping-in-ssrs-reports.aspx

=RowNumber("NameOfMyDataSet")

Where you will use group name in place of NameOfMyDataSet ...

=RowNumber("Group")

[Anonymous]

Great, thanks for sharing the links.