Getting token eof in power query
Solution 1:
Is that exactly your formula? If so you need to use the proper lower case on the if, and no ending period. Powerquery is case-sensitive
IF[Total_Sales]>25000 then [Total_Sales]*0.025 else 0.
should be
if [Total_Sales]>25000 then [Total_Sales]*0.025 else 0