Forum Discussion
Oros
Post Prodigy
Post ProdigyTrue/False, if statement
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....
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!
HotChilli
Community Champion
Community Championwhat have you tried so far?