True/False, if statement

[Oros]

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.

[dhruvinushah · Accepted 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!

[Oros]

Thanks @dhruvinushah 

[HotChilli]

what have you tried so far?