Forum Discussion

Sykboardrider's avatar
Sykboardrider
Frequent Visitor
6 years ago
Solved

Column comparison output

Hi All.

 

I am quite new to PBI and I am a little stuck with something.

I am trying to create a new column that is can provide me with the following output.

 

Value AValue BNew Column
TrueFalseFalse
TrueTrueTrue
FalseTrueFalse
FalsefalseFalse
   
  • Anonymous's avatar
    Anonymous
    6 years ago

    Both TRUE is true?

    New Column = 

    yourTable[Value A]=TRUE() && your[Value B]=TRUE()

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Both TRUE is true?

    New Column = 

    yourTable[Value A]=TRUE() && your[Value B]=TRUE()

    • Sykboardrider's avatar
      Sykboardrider
      Frequent Visitor

      Anonymous

       

      Thank you very much, that worked perfectly!

  • judspud's avatar
    judspud
    Icon for Solution Supplier rankSolution Supplier

    Hi Sykboardrider 

     

    Please can you clarify the logic you would like to apply?

     

    is it if they are both true then true otherwise false?

     

    Thanks,

    George