Forum Discussion

rosh80's avatar
rosh80
Regular Visitor
8 years ago

DAX if statement syntax error

Hi,   I am unable to use the IF conditional clause when creating a custom column.    This is the DAX;  IF(TABLE.COLUMN = TRUE(),"a","b).  This seems to have work in the August release of Power B...
Reports
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi rosh80,

 

Which Power BI desktop version do you run? 

 

Based on my test in Power BI desktop version 2.52.4921.682 64-bit (November 2017), get data from SQL database in DirectQuery, create a calculated column like yours, the calculated column values display fine in the table visual. 

 

 

In your scenario, please run the same desktop version as ours. Make sure the data type of Column field is Bit in database assume you use SQL database. 

 

Best Regards,
Qiuyun Yu

 

  • rosh80's avatar
    rosh80
    Regular Visitor
    8 years ago

    I am using the November version. The database is Amazon Redshift and the datatype is boolean.

     

    Thanks

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Community Support
      8 years ago

      Hi rosh80,

       

      Do you run desktop November version 2.52.4921.682? 

       

      When you create this calculated column, is there any error throws out? 

       

      Which visual do you use to show calculated column value? 

       

      Could you share screenshots about the DAX and visual? Do mask sensitive data before uploading. 

       

      Best Regards,
      Qiuyun Yu

      • rosh80's avatar
        rosh80
        Regular Visitor
        8 years ago

        Thanks for your time.