Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi, I have created a DAX column to calculate the aggregate by lane but now I want to remove duplicate rows from the table. Can you please suggest how to do that?
Hi @ray1804 ,
//I realized later that this is a calculated table, please try nesting the DISTINCT() function on the outside of the table's expression.
1. You can select these columns.
2. Right-click and remove the duplicate.
result.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi -
You can use "Group By" in the "Transform" tab of Power Query. Use the advanced option and group by each row in order. Then when the grouping is done you can delete the column that holds the summary.
Here is an example you can cut-and-paste into the Advanced Editor and walk through to see what it does:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtQ30zcyMDJS0lEyAWIQHZJRWlScklgJZBoCsZ8ziGFkYKpnbq4Uq0O6llgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ShipDate = _t, Weekday = _t, WeekNumber = _t, DayOfWeek = _t, Quarter = _t, Lane = _t, AggregatedCubes = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"ShipDate", type date}, {"Weekday", Int64.Type}, {"WeekNumber", Int64.Type}, {"DayOfWeek", type text}, {"Quarter", Int64.Type}, {"Lane", type text}, {"AggregatedCubes", type number}}),
#"Grouped Rows" = Table.Group(#"Changed Type", {"ShipDate", "Weekday", "WeekNumber", "DayOfWeek", "Quarter", "Lane", "AggregatedCubes"}, {{"Count", each _, type table [ShipDate=nullable date, Weekday=nullable number, WeekNumber=nullable number, DayOfWeek=nullable text, Quarter=nullable number, Lane=nullable text, AggregatedCubes=nullable number]}}),
#"Removed Columns" = Table.RemoveColumns(#"Grouped Rows",{"Count"})
in
#"Removed Columns"
Hope this helps!
Peter
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
14 | |
13 | |
12 | |
12 | |
12 |