Forum Discussion
Combine two files remove duplicate row when two columns have same value
I have a report that runs daily from our ERP that contains shipping history for current month. I need to combine the report that was run today with the report that was run yesterday. My issue is this...
SergeiBaklan i am not aware of how to use the that you are suggesting in SharePoint or in PBI that would allow me to remove duplicates from two columns. I’m only aware of it being able to remove duplicates from one column. Please on how to remove duplicates as i Originally asked in my post
Power Query for it
let
Source = Excel.CurrentWorkbook(){[Name="Source"]}[Content],
#"Removed Duplicates" = Table.Distinct(Source)
in
#"Removed Duplicates"which gives