Hello,
I have a table with week numbers as headers and a column of names, and the table has varying rates.
In excel, I would use Xlookup to find the corresponding rate from the week number and name.
What is the syntax in Power Query to achieve the same?
Any help is greatly appreciated
Kevin
It would depend a lot on how you are trying to use it but a simple way would be to unpivot the table so your week numbers all end up in one column and then merge that to your source using the week number and name.
Everyone who confuses correlation and causation ends up dead.
Thank you Rory
I have two criteria, name and week number.
I had thought about doing it the way you suggest but I have 500+ names and growing daily which would mean 26,000 rows.
Thanks
Kevin
The unpivoting happens in PQ not in the worksheet, so I don't see that it matters?
Okay, thanks.
I am not that familiar with PQ. I will have a look and try understand the unpivot option
Just FYI it would be useful to see a sample workbook to see the context of how you are trying to use this. There is always more than one way to do something and the best way depends on the context.
Thank you Rory..... it solved my problem
Kevin
Glad we could help, and thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks