Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to Use NOT IN Query in PowerBI DAX

I have imported Order table from SQL into PowerBI Order Table has Data Like below. ID OrderNo CustomerNo OrderDate 1 DC001 1001 2020-06-01 1 DC002 1002 2020-0...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    try the below 

    NOT 'Order'[CustomerNo] IN indexList

    or

    NOT ( 'Order'[CustomerNo] IN indexList )

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Anonymous 

 

try the below 

NOT 'Order'[CustomerNo] IN indexList

or

NOT ( 'Order'[CustomerNo] IN indexList )

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn