Forum Discussion

evalromf's avatar
evalromf
Helper I
9 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
Helper I
8 years ago

Hi All

 

Just to give you more feedback about my data, this is what I have:

 

1 - An excel table which contains a column (Request (Project & Ad Hoc) where one of these 4 letters can be found, and each letter represents a number as follows

F = 70

P = 80
G = 100
E = 116

2 - So I require to transform these letters into their respective values so I can use it in further calculations.

 

 

GilbertQ's avatar
GilbertQ
Super User
8 years ago
Hi there

Will it have the individual number in the column?

If not if you could post some sample data of what the column currently looks like
  • RodrigoTXRA's avatar
    RodrigoTXRA
    Helper 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
      Super 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
        Helper 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