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

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi,

        Thank you for your help, unfortunately I could not make it work with your proposed solution. I removed my Revenue and Cost columns and kept the year, company and the Year-to date column that I calculated from Revenue. It looks fine now.