Forum Discussion

BBurnett's avatar
BBurnett
Frequent Visitor
6 years ago
Solved

New Table with Column Names from other table data

I am trying to create a new table that has a single row based on primary ID and column names from values in the data but I just can't get it to do it. There is no need for an calculations as value fi...
Need Help
  • Washivale's avatar
    Washivale
    6 years ago

    Hello BBurnett ,

     

    You can achieve this with Pivot Function of Power Query, Go to Edit Query - Transform - Select value column - Pivot - then select Date from Drop Down and apply aggregation (if any) like Max date for the ID.

     

    Thank You,

    Washivale

  • JosefPrakljacic's avatar
    JosefPrakljacic
    6 years ago

    Hey BBurnett ,

     

    just do that stuff in the ScreenGif. Be careful regarding the aggregation type. You have 2 dates for Y and need to decide what to do with it.

     

    Explanation

     

    If this post was helpful may I ask you to mark it as solution and give it some kudos?

    Have a nice day!

    BR,
    Josef

     

Washivale's avatar
Washivale
Resolver V
6 years ago

Hello BBurnett ,

 

You can achieve this with Pivot Function of Power Query, Go to Edit Query - Transform - Select value column - Pivot - then select Date from Drop Down and apply aggregation (if any) like Max date for the ID.

 

Thank You,

Washivale