Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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://www.dotnetspider.com/resources/45773-grouping-in-ssrs-reports.aspx
=RowNumber("NameOfMyDataSet")
Where you will use group name in place of NameOfMyDataSet ...
=RowNumber("Group")
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://www.dotnetspider.com/resources/45773-grouping-in-ssrs-reports.aspx
=RowNumber("NameOfMyDataSet")
Where you will use group name in place of NameOfMyDataSet ...
=RowNumber("Group")
Great, thanks for sharing the links.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |