Formatting a column value based on other two column value

[Anonymous]

Hello All,

I have table which has two columns(Column-1 and Cloumn-2): I want to have another cloumn(let's say Column-3) which should have:

• If cloumn-1 is No AND cloumn-2 is No then the cloumn-3 value should be RED and background colur should be RED.
• If cloumn-1 is No AND cloumn-2 is Yes then the cloumn-3 value should be AMBER and background colur should be AMBER.
• If cloumn-1 is Yes AND cloumn-2 is No then the cloumn-3 value should be AMBER and background colur should be AMBER.
• If cloumn-1 is Yes AND cloumn-2 is Yes then the cloumn-3 value should be GREEN and background colur should be GREEN.

Thanks for your support.

[DataVitalizer · Accepted solution]

Hi @Anonymous 

Create a new calculated column using this DAX

Column3 = 
SWITCH(TRUE(),AND('Table'[cloumn-1]="No",'Table'[cloumn-2]="No"),"RED",OR(AND('Table'[cloumn-1]="No",'Table'[cloumn-2]="Yes"),AND('Table'[cloumn-1]="Yes",'Table'[cloumn-2]="No")),"AMBER","GREEN")

Did it work ? Mark it as a solution to help spreading knowledge.

A kudos would be appreciated  

[Anonymous]

Thanks very much. It worked.:)

[DataVitalizer]

You are welcome 👍