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

caio_queiroz — Sat, 12 Dec 2020 22:38:00 GMT

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?

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

Fowmy — Sun, 13 Dec 2020 10:28:41 GMT

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

topic Re: Conditional Column with two conditions (text columns) and IF result is a Column, else other colum in DAX Commands and Tips

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

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