Very simple text column comparsion

[rsbender]

I'm sorry but I am pretty new on Power BI.

I have a database that has some column and I want to compare two of then, with text format. If they have the same string I want a column or measure to return, let's say, "Equal" and if is different, "Different".

Column 1

A

B

C

A

Column 2  

A

C

B

B

Output

Equal

Different

Different

Different

I am sure its pretty simple, so that nobody ever asked this here

[v-juanli-msft · Accepted solution]

Hi @rsbender 

Create a column

Column = IF([column1]=[column2],"Equal","Different")

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rsbender]

It's curios because text string columns were simply not appearing, but for some reasion its working now

[rsbender]

I cant call text column using if, not sure if its normal...