Forum Discussion

pade's avatar
pade
Icon for Advocate III rankAdvocate III
5 years ago

Query Folding code for: SELECT * FROM T1 WHERE EXIST (SELECT 1 FROM T2 WHERE T1.C=T2.C)

I'm looking for a M-code that minic this SQL code: SELECT * FROM DimensionTable as d WHERE EXISTS (SELECT 1 FROM FactTable as f WHERE f.customerId = d.userId)   Edit: Please note that Query Fol...
Tips and Tricks
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
5 years ago
= Table.SelectRows(DimensionTable,each List.Contains(FactTable[customerId],[userId]))
  • pade's avatar
    pade
    Icon for Advocate III rankAdvocate III
    5 years ago

    Thanks wdx223_Daniel .

    Although, I can't see that this supports Query Folding, so it will take a very long time to execute on large tables