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, Kindly please help me
IF(SharePointList1[WorkStatus]="A" && SharePointList1[Status]="Completed", UNICHAR("128994"))
 
Anonymous Pradeep 
amitchandak 
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

3 Replies

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

    Hello Anonymous ,

     

    where do you want to use that? In a calculated column or a measure?

    If it's in a measure your columns need an aggregation:

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

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    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