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
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.