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.

v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

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.