Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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,
Solved! Go to Solution.
Hi @Kumarcy ,
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.
Hi @Kumarcy
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.
Hi @Kumarcy ,
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.
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.
User | Count |
---|---|
131 | |
108 | |
101 | |
67 | |
64 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |