Forum Discussion

Ha_Da's avatar
Ha_Da
Frequent Visitor
9 years ago
Solved

Problem about and/or logic in Power BI

In our products' data we have two kinds of versions. Version_Number and Terget version. In our previous query in other tool these two fields are or logic. But when I edit query in Power BI desktop it...
Need Help
  • Ha_Da's avatar
    Ha_Da
    9 years ago

    I found a advanced way to achieve or logic in Power BI Desktop. Using Advanced Options to add SQL Statement before loading data. Below is my SQL Statement. Thank you anyway.

     

    select * from [Table] where version_number ='V10.0' or Target_Rlease ='V10.0'

BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
9 years ago

In that case, You can build two queries and append one on another. This can satisfy your OR requirement. Unless there is no specific terms to filter, it will use only AND logic in the query.

Ha_Da's avatar
Ha_Da
Frequent Visitor
9 years ago

I found a advanced way to achieve or logic in Power BI Desktop. Using Advanced Options to add SQL Statement before loading data. Below is my SQL Statement. Thank you anyway.

 

select * from [Table] where version_number ='V10.0' or Target_Rlease ='V10.0'