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.
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
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:-
PlantId | Year | Month | Target (MT) | Production (MT) |
1 | 2015 | 4 | 10080 | 5003 |
1 | 2015 | 5 | 11345 | 6010 |
1 | 2015 | 6 | 12610 | 7017 |
6 | 2015 | 7 | 20000 | 20000 |
1 | 2015 | 8 | 15140 | 9031 |
1 | 2015 | 9 | 12405 | 8038 |
1 | 2015 | 4 | 10080 | 5003 |
1 | 2015 | 5 | 11345 | 6010 |
1 | 2015 | 6 | 12610 | 7017 |
6 | 2015 | 7 | 20000 | 20000 |
1 | 2015 | 8 | 15140 | 9031 |
1 | 2015 | 9 | 12405 | 8038 |
@surya_gupta , 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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
74 | |
51 | |
45 | |
16 | |
12 |