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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

How do i use row number function in power bi

How do i use row_number function in power bi

 

Code is:-

 

DELETE Sub FROM
(SELECT ROW_NUMBER() over ( PARTITION BY PlantId,CustomerId,Customer,Date,FirmOrders,ShippedQty order by PlantId) cnt
FROM Shipped) Sub
WHERE Sub.cnt>1

 

This code is for deleting each duplicate row from a table

3 REPLIES 3
Anonymous
Not applicable

Anonymous
Not applicable

I have A table which have duplicate records in rowwise, how to remove each duplicate rows, and table doesn't have any primary key column.

 

for Example:-

 

PlantIdYearMonthTarget (MT)Production (MT)
120154100805003
120155113456010
120156126107017
6201572000020000
120158151409031
120159124058038
120154100805003
120155113456010
120156126107017
6201572000020000
120158151409031
120159124058038
amitchandak
Super User
Super User

@Anonymous , Rank

 

new column

Rankx(filter(Table, [CustomerId] =  earlier([CustomerId])  && [CustomerId] =  earlier([CustomerId])  && [Customer] =  earlier([Customer])   && [Date] =  earlier([Date])  && [FirmOrders] =  earlier([FirmOrders])  && [ShippedQty] =  earlier([ShippedQty]) ), [PlantID],,asc,dense)

 

 

Then you can filter on that column

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.