Dynamic Unpivoting in Power Query

[TheHack22]

Hi All,

I'm very new to Power Query and DAX. I have a data set - a daily report that I'm trying to unpivot dynamically. The anchor columns A&B will never change. However, from columns C, these are daily reports a day (New Date will be added as Column Headers Plus the data (values) for those dates) will be added every time I add new data. How do I dynamically capture these new dates that will be added daily? I found this DAX online, but it's giving an error where there is the word "attribute". Can someone please help me to solve this?



let Source = Excel.CurrentWorkbook(){[Name=„ProductPlan“]}[Content],

Cols = Table.ColumnNames(Source),

ColsUnPivot=List.Skip(Cols, 1),

Unpivot = Table.Unpivot(Source,ColsUnPivot,„Attribute“,„Value“)

in

Unpivot

 

[Bo_Ry]

Try

let
    Source = Excel.CurrentWorkbook(){[Name="ProductPlan"]}[Content],
    Unpivot = Table.UnpivotOtherColumns(Source, {"Segment", "Key"}, "Attribute", "Value")
in
    Unpivot

 

[TheHack22]

Try

let
    Source = Excel.CurrentWorkbook(){[Name="ProductPlan"]}[Content],
    Unpivot = Table.UnpivotOtherColumns(Source, {"Segment", "Key"}, "Attribute", "Value")
in
    Unpivot

@Bo_Ry

Thanks very much. This works perfectly. You're the best.
Imran

 

[smozgur]

Thanks very much. This works perfectly. You're the best.
Imran

I switched the solution post as it was also confirmed.

@Imran_IsshackNY: In the future, please mark the post that worked perfectly and naturally answered your question, not your last post unless you post your own question.

 

[TheHack22]

I switched the solution post as it was also confirmed.

@Imran_IsshackNY: In the future, please mark the post that worked perfectly and naturally answered your question, not your last post unless you post your own question.

Thanks for your note. I'm still learning how to use this site. Will do so in future posts.
Imran

 

[smozgur]

Now you selected my post as the answer, so still not quite right, but that's ok.

For your future questions, you just need to mark the post that answered your question, which was #2 in this thread. I already switched the marked solution for this thread, so there is no further action is necessary for this question.

Will do so in future posts.

Thanks. It helps future readers if we do so.

 

[TheHack22]

Now you selected my post as the answer, so still not quite right, but that's ok.

For your future questions, you just need to mark the post that answered your question, which was #2 in this thread. I already switched the marked solution for this thread, so there is no further action is necessary for this question.


Thanks. It helps future readers if we do so.

This is weird. It's showing the #2 mark as the solution on my end.

 

[smozgur]

This is weird. It's showing the #2 mark as the solution on my end.

Because I changed it again.

There is nothing more to do in this thread.

 

[TheHack22]

Because I changed it again.

There is nothing more to do in this thread.

Thanks

 

[smozgur]

Thanks

?