Forum Discussion

datalineage88's avatar
datalineage88
New Member
5 years ago

EXISTS AND IN function SQL to Dax help

Hi All, New to the forums, and I have a very interesting scenario to solve for. Hoping to get some help or advice! I am building a report off a cube/dataset.    Ideally I would like to create th...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

Rewrite your SQL to convert the where clause to a join between fact 1 and fact 2.  That should also give you the needed pointer on how to convert that to a Power BI data model.