Forum Discussion
How to access column in another table through bridged table?
This is what relationship looks like: They had many to many relationship but then I created a bridge table Calendar. I need to get number of orders placed the next day. This dax just works fin...
Yes, both of them have customer Ids.
andhiii079845
Solution Sage
Solution SageOne idea: bring both table with a composite of the customerID-date together. You can than filter both tables with this combination? I think you have to invest more time in the data modelling topic.
Perhaps you can merge both tables?
Merge isnt working as expected. I am merging both tables using full outer join and it only gives me matched rows and not mismatched rows