Apply a percentage when a number is greater than 500

[Anonymous]

I have a table with a cost column, I would like to create another column applying a percentage discount only on values over £500.

[MFelix · Accepted solution]

Hi @Anonymous ,

You should use something similar to this:

Column = IF('Table'[Value] < 500; 'Table'[Value]; 'Table'[Value] * (1- 0,1))

You should replace the 0,1 by your discount value.

Regards,

MFelix 

[Anonymous]

Great thanks for your help!