Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
102 | |
91 | |
84 | |
77 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |