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

[caio_queiroz]

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?

[Fowmy]

@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