Forum Discussion
Two columns from two tables
Hi Power BI Community! I have two tables with each column of supplier names. I want to used the combination as a slicer. I want to combine these two but I tried appending and merging. Nothing wor...
Anonymous , You can create new common/bridge table and join with both tables
new table = distinct(union(all(Table1[supplier]), all(Table2[supplier])))
or
distinct(union(distinct(Table1[supplier]), distinct(Table2[supplier])))
refer to my video
Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19
Anonymous , You can create new common/bridge table and join with both tables
new table = distinct(union(all(Table1[supplier]), all(Table2[supplier])))
or
distinct(union(distinct(Table1[supplier]), distinct(Table2[supplier])))
refer to my video
Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19