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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Swamy3105
Helper IV
Helper IV

Sequence number

Hi Experts,

 

I want to get the sequence number for the partcel ref as below:

 

seq_no.JPG

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@Swamy3105 , First of all you need add an index column in power query and then try this new column in dax :https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

 

Seq_no = countx(filter(Table,[Parcel_ref] =earlier([Parcel_ref]) && [index] <=earlier([index])), [Parcel_ref])

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

Sumanth_23
Memorable Member
Memorable Member

hi @Swamy3105 , in addition to solution provided by @amitchandak  - if the "Parcel_Ref" is not a unique field then you may have to create a "Key" column and add a seq_no column based on the key column 

 

Seq_no = countx(filter('OrderDetails',[Key] =earlier([Key]) && [Index] <=earlier([Index])), [Key])

 

Sequence Number.jpg

 

Please mark the post as a solution if my comment helped with solving your issue. Thanks! 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!

Proud to be a Super User!



View solution in original post

2 REPLIES 2
Sumanth_23
Memorable Member
Memorable Member

hi @Swamy3105 , in addition to solution provided by @amitchandak  - if the "Parcel_Ref" is not a unique field then you may have to create a "Key" column and add a seq_no column based on the key column 

 

Seq_no = countx(filter('OrderDetails',[Key] =earlier([Key]) && [Index] <=earlier([Index])), [Key])

 

Sequence Number.jpg

 

Please mark the post as a solution if my comment helped with solving your issue. Thanks! 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!

Proud to be a Super User!



amitchandak
Super User
Super User

@Swamy3105 , First of all you need add an index column in power query and then try this new column in dax :https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

 

Seq_no = countx(filter(Table,[Parcel_ref] =earlier([Parcel_ref]) && [index] <=earlier([index])), [Parcel_ref])

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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