Forum Discussion
Issue linking two tables
Hi,
I have two data tables with below information. I'd like to use them as slicer. How can i link thiese two table since second table has more manufacturers listed than the first one. When i create a relation in Power Query Editor it doesnt work. All my measures are created using the Region Manufacturer table and doesnt respond to changes to slicere created using POS Manufacturer table. Is there any work around this?
dokat , One way is to append these table
Second, create common dimension tables and create join
https://www.seerinteractive.com/blog/join-many-many-power-bi/
4 Replies
dokat , One way is to append these table
Second, create common dimension tables and create join
https://www.seerinteractive.com/blog/join-many-many-power-bi/
amitchandak Thank you for your response. Both tables have different columns. Will it still work?
amitchandak Thank you for your response. Both tables have different columns. Will it still work?
amitchandak I successfully created the bridge table however slicer still doent change matrix tale results.
