Forum Discussion
Solved
BLANK fields after left join doesnt exist
Hello all, in SQL i can simply do following query SELECT * FROM Table1 A LEFT JOIN (SELECT * FROM Table2 WHERE origin = 'ANALYSE') B ON A.PK1 = B.PK2 WHERE B.PK2 IS NULL In DAX: Meas...
I found a way using NATURALLEFTOUTERJOIN(Table1, Table2) and work on that with a measure. A simple relationship seems not to generate a LEFT JOIN behaviour like in SQL. Or does someone knows a way to do it without creating a new NATURALLEFTOUTERJOIN Table?
I found a way using NATURALLEFTOUTERJOIN(Table1, Table2) and work on that with a measure. A simple relationship seems not to generate a LEFT JOIN behaviour like in SQL. Or does someone knows a way to do it without creating a new NATURALLEFTOUTERJOIN Table?