Set the UNCHAR value based on IF , AND consitions

[Anonymous]

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 

[selimovd]

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

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

@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 · Accepted solution]

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