Forum Discussion
Connecting two tables by multiple fields
Hi! I have 3 tables. Country table has an active relationship with Sales Documents and Billing Documents, and is filtering the Country column in these tables. I need to connect Sales Document...
kzielinska , According to me you need to create common dimesions. It may be one or more and use that for analysis.
I explained the same using DAX and Power query
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda
Power BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw