Forum Discussion

caio_queiroz's avatar
caio_queiroz
Frequent Visitor
5 years ago

Conditional Column with two conditions (text columns) and IF result is a Column, else other colum

Guys

 

i need to create a cond. column based on two other columns conditions, i tried many ways, but powerbi tell me that i cant use the IF for differente data type (Text and numbers)

E.g. IF (Table1[Column1} = "A" && Table1[Coluumn2} = "Brazil", Table1[CostAdjusted, Table1[Cost])

Can you help me?

1 Reply

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    5 years ago

    caio_queiroz 

    Please if your column1 and column2 are having text data and have the data type as text.

    New Column = 
IF (
    AND( Table1[Column1] = "A" , Table1[Column2] = "Brazil"), 
    Table1[CostAdjusted],
    Table1[Cost]
)

     

    You can share your screenshot fo the table where ou are trying to add the column with the error message

    ________________________

    If my answer was helpful, please click Accept it as the solution to help other members find it useful

    Click on the Thumbs-Up icon if you like this reply 🙂


    Website YouTube  LinkedIn