Forum Discussion
Alternative to unpivot in powerquery
Hi Everyone, I have two tables which has many columns and rows, so just posting really a sample of it. Is there any way to get the Description column values from the Entries table without unpivot...
lbendlin
Super User
Super UserYou could do a lookup via Table.SelectRows. But it would be better to split the Entries table into separate dimension tables, and then let the data model do the work for you.
Thanks a lot for your reply.However, I have many columns in Entries table, so that would mean so many dimension tables, so not very sure if there is any other way rather than unpivot?