Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

populating a column based on value in another column

Hi All,   I'm sure this has been answered before, but i've spent an hour looking for it and so far haven't been able to find what i need.   I have 3 columns shown below, what i need to do is take...
Need Help
  • AntonioM's avatar
    AntonioM
    4 years ago

    Hi Anonymous ,

     

    You could do this in Power query using the 'Add Conditional Column',

     

     

    which will give you

     

     

     

AntonioM's avatar
AntonioM
Solution Sage
4 years ago

Hi Anonymous ,

 

You could do this in Power query using the 'Add Conditional Column',

 

 

which will give you

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi AntonioM ,

     

    I'm going to accept this as the solution, as I am sure that is the way to do it, but my powerBI doesn't have that add column tab, will have to find out how to get that.

     

     

    Thanks,

     

    Jeff

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Jeff, that's because AntonioM says to do it in Power Query, not in Power BI. To go there, you have to click on the “Transform Data” button (it appears in your picture) and then follow his instructions.

      Greetings.