Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have this 1 table that I would like to create an IF, ELSE column (or a measure) to replace the REGULAR PRICE
ITEM | REGULAR PRICE | DISCOUNTED |
BANANA | $5 | |
APPLE | $10 | |
MANGO | $20 |
If discounted=YES, then the price column becomes $1. If discounted=NO, then regular price.
Thanks.
Solved! Go to Solution.
Hello @vojtechsima ,
Thanks for the prompt reply. I get an error message. (DAX comparison operations do not support comparing values of type True?False with values of type Text.)
Hi, @Oros ,
Make sure your columns are in proper data types, when comparing string ("YES", "NO") the column has to be a text, if numeric values (1,2) it has to be Numeric. PLease check that and try running itagain
Hello @vojtechsima ,
I change it to text but got another error:
"Expressions that yield variant data-type cannot be used to define calculated columns."
Any idea?
Thanks.
Hello @Oros ,
Add a calculated column-
NewColumn = IF(Data[DISCOUNTED]="YES",1,Data[REGULAR PRICE])
Please mark it as answer if it resolves your issue. Kudos are also appreciated.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |