Forum Discussion
Serial number based on a condition
I have multiple excel files that are connected to a network path.
I'd like to populate a S.NO column that will output row values based on the start date.
Example of 3 sample excel files:
Sample 1
| Start Date | Application |
| 02/25/2024 | Test ABC |
| 02/25/2024 | Test BCC |
| 02/25/2024 | Test ACA |
| 02/26/2024 | Test BCA |
| 02/26/2024 | Test BCD |
| 02/26/2024 | Test FBC |
Sample 2
| Start Date | Application |
| 02/26/2024 | Test ABC |
| 02/26/2024 | Test BCC |
| 02/26/2024 | Test ACA |
| 02/27/2024 | Test BCA |
| 02/27/2024 | Test BCD |
| 02/27/2024 | Test FBC |
Sample 3
| Start Date | Application |
| 02/27/2024 | Test ABC |
| 02/27/2024 | Test BCC |
| 02/27/2024 | Test ACA |
| 02/28/2024 | Test BCA |
| 02/28/2024 | Test BCD |
| 02/28/2024 | Test FBC |
Desired Outputs:
When Start Date is 02/26/2024 then the below column with S.NO row values must be populated
| Start Date | Application | S.NO |
| 02/26/2024 | Test ABC | 1 |
| 02/26/2024 | Test BCC | 2 |
| 02/26/2024 | Test ACA | 3 |
| 02/26/2024 | Test BCA | 4 |
| 02/26/2024 | Test BCD | 5 |
| 02/26/2024 | Test FBC | 6 |
When Start Date is 02/27/2024 then the below column with S.NO row values must be populated
| Start Date | Application | S.NO |
| 02/27/2024 | Test ABC | 1 |
| 02/27/2024 | Test BCC | 2 |
| 02/27/2024 | Test ACA | 3 |
| 02/27/2024 | Test BCA | 4 |
| 02/27/2024 | Test BCD | 5 |
| 02/27/2024 | Test FBC | 6 |
I did find the solution for this problem at the link below.
https://radacad.com/create-row-number-for-each-group-in-power-bi-using-power-query
3 Replies
I did find the solution for this problem at the link below.
https://radacad.com/create-row-number-for-each-group-in-power-bi-using-power-query
Hi geeklarokcmie ,
You can add the index column in Power Query.
Add an index column - Power Query | Microsoft Learn
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Adding an index column will list rows from 1 to nth number - which does not work for me.
I'm looking for a solution -
If i filter a start date of 26th and there are 25 records then i want to see a new column with id's as 1 ,2 ,,, 25 and if i filter a start date 27th and there are 15 records then i want to see the column with id's as1,2,3,...15.
