2 are dimension tables for the SKU codes and for the Market hierarchy.
The other two are:
One source contains the order data (S1). The other contains (S2) constraints data.
I have connected S1 and S2 via full outer join and getting something like this:
Now the issue is that I m unable to connect it to dimension table because of some blank rows. If I connect it via S1.code then I miss some data in Source 2 (eg for code 130).
In excel I coul add a column which says if S1.code or S2.code is blank, we should take the not blank value. But how do I do this in PowerBI so that I can create a relationship and all data is captured?