Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Set the UNCHAR value based on IF , AND consitions

Hello All,   I am very new to Power BI and trying to set the UNICHAR value using IF with AND statement  Below is the DAX expersion using neither I am getting error nor value with beow expression,...
Need Help
Show and Tell
Tips and Tricks
  • selimovd's avatar
    selimovd
    5 years ago

    Hey Anonymous ,

     

    as a calculated column the formula seems to be correct.:

    myColumn = IF(SharePointList1[WorkStatus]="A" && SharePointList1[Status]="Completed", UNICHAR("128994"))

     

    Did you add it to the table SharePointList1?

    Do you receive an error message?

     

    Best regards

    Denis

Anonymous's avatar
Anonymous
Not applicable
5 years ago

selimovd tq for your balze reposne , I need the experssion in Calulated Column .
But I didn't find luck to the expersion . Please extend your support.

selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hey Anonymous ,

 

as a calculated column the formula seems to be correct.:

myColumn = IF(SharePointList1[WorkStatus]="A" && SharePointList1[Status]="Completed", UNICHAR("128994"))

 

Did you add it to the table SharePointList1?

Do you receive an error message?

 

Best regards

Denis