Hi @jboschee34 ,
One possible way to get rid of the duplicates is to use a group by operation in Power Query. You can group by the order_number and sku columns, and then apply an aggregation function to the Tracking ID column, such as max, min, or count. This will reduce the number of rows and show only one value for each combination of order_number and sku.
To perform a group by operation in Power Query, you can follow these steps:
Click on the Home menu and select the Group by option.
Select the order_number and sku columns as the Group by columns.
Select the Tracking ID column as the New column name.
Select an aggregation function, such as Max, Min, or Count from the Operation drop-down list.
Click OK.
Many-to-many relationship guidance - Power BI | Microsoft Learn
How to Get Your Question Answered Quickly
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.
