Forum Discussion
Calculating multiple column values using a row value
See there're 2 tables Table 1 & Table 2. I need to get the sum for row values of table 1 from columns of table 2.
Anonymous
First, you need unpivot our Table 2 so you will have three columns as you need in Power Query:
https://www.youtube.com/watch?v=Vff2kRBM95o
I already tried unpivoting the columns but it would increase the loading time way more for the data is more then 100Mn rows. if i don't unpivot the loading time is 2 minutes approx but if i do the loading time jumps to 1hr.