Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I need to add a column (FINAL PRICE) that is based on another column (TRUE/FALSE). If the product discounted=FALSE, then multiply REGULAR PRICE by one (1), otherwise put DISCOUNTED PRICE. Thanks.
Solved! Go to Solution.
Hi @Oros ,
Assuming your table's datatype for the Discounted Column is formatted like this:
Try this to create your FINAL_PRICE column:
Final Price = IF( 'True False'[Discounted]=TRUE(), 'True False'[Discounted Price], 'True False'[Regular])
Hope this helps, tag me (@) if you need more help on it. Feel free to mark the answer as a solution if it helped you.
Thanks!
Hi @Oros ,
Assuming your table's datatype for the Discounted Column is formatted like this:
Try this to create your FINAL_PRICE column:
Final Price = IF( 'True False'[Discounted]=TRUE(), 'True False'[Discounted Price], 'True False'[Regular])
Hope this helps, tag me (@) if you need more help on it. Feel free to mark the answer as a solution if it helped you.
Thanks!
what have you tried so far?
User | Count |
---|---|
80 | |
76 | |
70 | |
69 | |
54 |
User | Count |
---|---|
104 | |
99 | |
92 | |
78 | |
69 |