Create a new calclated column from a percentage with an IF statement

[alawode]

Hi Experts,

I have a column with walues in this format "100.00%". i amd trtying to write the following If statement"

(IF Table_Name[Profit] = 100.00%,1,0).

The problem is that it doesnt seem to recognize the "100.00% fromat in the expression. Is there anoter way to write this expression?

Thanks in advance, i have attached the sample data.

[AlexisOlson · Accepted solution]

100% = 1, so you should be able to write

IF ( Table_Name[Profit] = 1, 1, 0 )

or

IF ( Table_Name[Profit] < 1, 0, 1 )