Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

And OR not working in power Query

I have the below code and in this part AND and OR part is not working.KIndly help if [Control]="ENG0N" and ([SubControl]="ENG0N.A6" or [SubControl]="ENG0N.IPE") then [Month]&[Year]&[SubControl] e...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    I completely agree with this solution but somehow in some cases the combination of OR and <> is not working properly. In my case, for some blocks its working and for some its not though the logic is same. So, instead of OR and <> I have used nested if else again.

     

    Thanks,

    Shweta

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Apologies,posting the rith screenshot(chnaged B field)

Criteria is to check B field first and if it matches then check A field for A6 and IPE and do the concatenation.

Kindly help..I have to do this in power query

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

Are there any spelling errors in these positions? Try replacing 0 with o.

if [Control]="ENGON" and ([SubControl]="ENGON.A6" or
[SubControl]="ENGON.IPE")
then [Month]&[Year]&[SubControl]
else if [Control]="ENGON" and ([SubControl]<>"ENGON.A6" or
[SubControl]<>"ENGON.IPE")
then [Month]&[Year]&[SubControl]
else null

Note that the type of each column must be text in order to use the & link.

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum