Forum Discussion
Solved
Multiple Relationships Between Tables
Hello, I am pretty new in power bi with some knowledge from here and there and a lot of google search... My issue is this: I have two tables (one with actuals and one with targets) both with ...
Hi Dimis_e
you need to create a model like the below. The top dimension table will filter both sales and actuals
Concatenate the 2 fields and make a join based on the concatenated field.
It will be 2 tables with many to many relationship