Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Error in 'EVALUATE' - dax

Hi,   I have an sql query in which there are multiple conditions in where clause. I want to implemet that in dax and for that I am using evaluate function in calculate column. But it gives me error...
Need Help
Show and Tell
Tips and Tricks
  • TeigeGao's avatar
    TeigeGao
    7 years ago

    Hi Anonymous ,

    In PowerBI, we can use DAX query directly, it is not supported to use EVALUATE() function. This function is used when executing DAX query in SQL Server Management Studio (SSMS) and open-source tools like DAX Studio, please refer to this document: https://docs.microsoft.com/en-us/dax/dax-queries.

    To convert your SQL query to DAX query, you can use AND() and OR() function in DAX, like below:

    OR(id >= 1 && id <= 100, id in {105,110, 115})

    Best Regards,

    Teige

TeigeGao's avatar
TeigeGao
Icon for Solution Sage rankSolution Sage
7 years ago

Hi Anonymous ,

In PowerBI, we can use DAX query directly, it is not supported to use EVALUATE() function. This function is used when executing DAX query in SQL Server Management Studio (SSMS) and open-source tools like DAX Studio, please refer to this document: https://docs.microsoft.com/en-us/dax/dax-queries.

To convert your SQL query to DAX query, you can use AND() and OR() function in DAX, like below:

OR(id >= 1 && id <= 100, id in {105,110, 115})

Best Regards,

Teige