Forum Discussion

Anonymous

Not applicable

6 years ago

SQL to DAX Help Needed - Left join with ADD few columns

Fact ID Name 1 A 2 B 3 C DIM ID Name 2 A 3 B Result Expected Fact ID 3 Modifying my post Hi Guys, Can you help me with a DAX que...

Helper I

6 years ago

It sounds like you may be able to use EXCEPT... something like this:

EXCEPT(SUMMARIZE('Fact', Fact[ID]), SUMMARIZE(DIM, DIM[ID]))

You indicated the result you expected was Fact ID = 3, but based on your SQL, I think you meant to return the 1 value. Is that right?