Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper II
Helper II

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 DateApplication
02/25/2024Test ABC
02/25/2024Test BCC
02/25/2024Test ACA
02/26/2024Test BCA
02/26/2024Test BCD
02/26/2024Test FBC

Sample 2

Start DateApplication
02/26/2024Test ABC
02/26/2024Test BCC
02/26/2024Test ACA
02/27/2024Test BCA
02/27/2024Test BCD
02/27/2024Test FBC

Sample 3

Start DateApplication
02/27/2024Test ABC
02/27/2024Test BCC
02/27/2024Test ACA
02/28/2024Test BCA
02/28/2024Test BCD
02/28/2024Test FBC

Desired Outputs:

When Start Date is 02/26/2024 then the below column with S.NO row values must be populated

Start DateApplicationS.NO
02/26/2024Test ABC1
02/26/2024Test BCC2
02/26/2024Test ACA3
02/26/2024Test BCA4
02/26/2024Test BCD5
02/26/2024Test FBC6

When Start Date is 02/27/2024 then the below column with S.NO row values must be populated

Start DateApplicationS.NO
02/27/2024Test ABC1
02/27/2024Test BCC2
02/27/2024Test ACA3
02/27/2024Test BCA4
02/27/2024Test BCD5
02/27/2024Test FBC6
Helper II
Helper II

Helper II
Helper II

I did find the solution for this problem at the link below.

Community Support
Community Support

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.





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.

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.


Fabric certifications survey

Certification feedback opportunity for the community.