add a custum column (If condition error)

[tinjade]

Dear All,

I have a big problem in  custum column for IF condition as below image. After typing "then", it show error "Token Eof expected". Please help me and Thank in advance.

[Idrissshatila · Accepted solution]

Hello @tinjade ,

Try using conditional column in your case, check it in the following link:

https://learn.microsoft.com/en-us/power-query/add-conditional-column

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[tinjade]

Thank you very much for quick response. It solved!

[Greg_Deckler · Accepted solution]

@tinjade IF needs to be if and you need an else statement as well I believe.

[tinjade]

Thank you very much for quick response. It solved!

[Idrissshatila · Accepted solution]

Hello @tinjade ,

Try using conditional column in your case, check it in the following link:

https://learn.microsoft.com/en-us/power-query/add-conditional-column

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin