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

Below is the screenshot

Basically if its A6 and IPE I dont want to concatenate week else include week in the concatenation.

I have given expected output. Error which I am facing is for all A field I am getting week in the concatenated field.

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