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

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.

Reply
geeklarokcmie
Helper I
Helper I

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
1 ACCEPTED SOLUTION
geeklarokcmie
Helper I
Helper I

3 REPLIES 3
geeklarokcmie
Helper I
Helper I

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

v-rongtiep-msft
Community Support
Community Support

Hi @geeklarokcmie ,

You can add the index column in Power Query.

Add an index column - Power Query | Microsoft Learn

vrongtiepmsft_0-1709084734713.png

 

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

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.