Dax formula "IF" - Condition that 2 texts are different

[Elofly]

Hi everyone!

I am trying to set up a formula for a new measure with a IF condition.

I have actually 2 columns: Actual Room Name and New Room Name both with text values.

I would like to add a column that identifies when the Actual Room Name is different from the New Room Name.

And I was thinking using the IF value like I use in Excel...

Could you help me to redact the formula?

Thanks a lot!

Elofly

[coskuersanli · Accepted solution]

Hi @Elofly 

You may use SELECTEDVALUE().

IF(SELECTEDVALUE(actual_room) = SELECTEDVALUE(new_room), True, False)

[Elofly]

Thank you so much!

[coskuersanli · Accepted solution]

Or you can just use EXACT() and add a column 🙂

[coskuersanli · Accepted solution]

Hi @Elofly 

You may use SELECTEDVALUE().

IF(SELECTEDVALUE(actual_room) = SELECTEDVALUE(new_room), True, False)