Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Power Query If condition

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. ...
Need Help
  • Mikelytics's avatar
    Mikelytics
    5 years ago

    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's avatar
darentengmfs
Post Prodigy
5 years ago

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.