Custom Column Formula Error

[Anonymous]

Hi Experts

Cannot see the error in the following If statement Custom Column Power Query

= if([Amt]=[Coupon] then [amt] else [amt] +[Coupon])

[selimovd · Accepted solution]

Hey @Anonymous ,

the backets don't fit. Try:

= if [Amt] = [Coupon] then [amt] else [amt] + [Coupon]

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

thanks brackets error