Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Conditional columns

Hi,   I have a table with monthly company data for 3 years. I am trying to reshape my table and make new columns for some of the metrics using conditional columns. My table looks like below:   ...
Need Help
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, Anonymous 

Inside the Power Query Editor, 

1. filter out the Tax rows

2. select Metric Name and Materic value columns

3. pivot those

4. Selecte Value column as Metric Value

 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi,

    Jihwan_Kim Unfortunately the problem with date still exists. I did not get one row for january with Revenue and Cost values in the same row...

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Icon for Super User rankSuper User
      5 years ago

      Hi, Anonymous 

      Thank you for your feedback.

      In your sample case, I see that your desired outcome also showed two rows for Jan.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Jihwan_Kim  I see the confusion. That is for another company (company B). So I'd like to have one row for each month per company 🙂 .