Serial number based on a condition

[geeklarokcmie]

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

[geeklarokcmie · Accepted solution]

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

[Anonymous]

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 _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[geeklarokcmie]

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.