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.
I have 2 separate tables to store products. Although it is 2 different tables, their structure is exactly the same.
In these tables, each line has an item and the indication to which departments it should be made available.
However, because there are 2 tables, the same item can appear in the tables and in each one marking different departments.
I would like to make a table unifying the 2 previous ones and making sure that the item that appears repeated in the tables does not come out in 2 lines but that its line is merged, pointing in the new table the departments of the 2 tables.
Obviously this concept of departments is not real, I just used it to try to better explain my situation.
Please can you help me to resolve this?
Solved! Go to Solution.
Hello - here is how you can accomplish this.
SCRIPT
let
Source = Table.Combine({Table01, Table02}),
#"Unpivoted Columns" = Table.UnpivotOtherColumns(Source, {"Product"}, "Attribute", "Value"),
#"Filtered Rows" = Table.SelectRows(#"Unpivoted Columns", each ([Value] = "x")),
#"Pivoted Column" = Table.Pivot(#"Filtered Rows", List.Distinct(#"Filtered Rows"[Attribute]), "Attribute", "Value")
in
#"Pivoted Column"
That's perfect!
Hello - here is how you can accomplish this.
SCRIPT
let
Source = Table.Combine({Table01, Table02}),
#"Unpivoted Columns" = Table.UnpivotOtherColumns(Source, {"Product"}, "Attribute", "Value"),
#"Filtered Rows" = Table.SelectRows(#"Unpivoted Columns", each ([Value] = "x")),
#"Pivoted Column" = Table.Pivot(#"Filtered Rows", List.Distinct(#"Filtered Rows"[Attribute]), "Attribute", "Value")
in
#"Pivoted 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.