Forum Discussion

evalromf's avatar
evalromf
Icon for Helper I rankHelper I
10 years ago

AND IF in conditional column

Hi,   I'm trying to create a new column that should be populated with a certain number based on the contents of several other columns.   What I'm looking for is something like this:   If [COUNT...
Need Help
RodrigoTXRA's avatar
RodrigoTXRA
Icon for Helper I rankHelper I
8 years ago

GilbertQ please see screen shot of the excel table below. The column in black is the one I have issues with. This column comes with a letter instead of those numbers. Let me know if you require more info

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
8 years ago

Hi there

Thanks for the screenshot.

 

What you could do, is go into the Power Query Editor, click on Add Conditional Column from the Add Column Ribbon.

 

Then you can use the conditional logic in which you can put in your requirements as shown below.

 

  • RodrigoTXRA's avatar
    RodrigoTXRA
    Icon for Helper I rankHelper I
    8 years ago

    GilbertQ, YES, this solved the issue. I expect to ge to the calculations and hope everything goes well.

    Thank you VERY much for your assistance on this

    Regards

    Rodrigo

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      8 years ago

      Hi RodrigoTXRA

       

      Happy to assist and get it working for you.