Forum Discussion

rsbender's avatar
rsbender
Frequent Visitor
6 years ago
Solved

Very simple text column comparsion

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

Need Help
Tips and Tricks
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    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.

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    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's avatar
      rsbender
      Frequent Visitor
      6 years ago

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

  • rsbender's avatar
    rsbender
    Frequent Visitor
    6 years ago

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