Power Query If condition

[Anonymous]

Hello Power Users,

I'm trying to write some multiple if statements in Query editor(Power query) but i'm not able to get the correct answer.  I have written below syntax but i'm missing something.  else if then else if line is not working properly.

Syntax:
if [Column A] = "ABCD" then [Start Date]
        else if [Column A] = "BCFD" then [Start Date]
  else if [Column A] = "QWER" then [Submission Date]
  else if [Column A] = "IUYT" then
                                            each if [Column B] = "lkjh" then [Submission Date]
                                            else if [Column B] = "hygt" then [End Date]
                                            else if [Column B] = "bgfd" then [End Date"]
                                            else null           
  else [#End Date"]

Please help me.

Thanks,

[v-jingzhang]

Hi @Anonymous 

Have you tried solutions in above replies? If you have solved it, kindly accept the appropriate reply as the solution or post your own solution. If not, can you share more info about how it is going now so that we can help further. Thanks.

[Mikelytics · Accepted solution]

Hi @Anonymous ,

Can you try thw folloing please?

if [Column A] = "ABCD" then [Start Date]
        else if [Column A] = "BCFD" then [Start Date]
  else if [Column A] = "QWER" then [Submission Date]
  else if [Column A] = "IUYT" then
                                            (if [Column B] = "lkjh" then [Submission Date]
                                            else if [Column B] = "hygt" then [End Date]
                                            else if [Column B] = "bgfd" then [End Date"]
                                            else null)           
  else [#End Date"]

 Best regards

Mikelytics

Did I solve your request? Please mark my post as solution.

Appreciate your Kudos.

[darentengmfs]

@Anonymous 

Hi, do you have a typo in your syntax? Please take a look at what you posted.

Also, I think you have an extra "else statement" at the end.