Forum Discussion
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 (T...
Fowmy
Super User
Super Usercaio_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 🙂