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 works as a slicer.
What is the right way to do it?
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
1 Reply
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