Forum Discussion
Calculating multiple column values using a row value
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.
Anonymous
I would still advise you to re-organize your data as you have a large amount. You have it done at the source level. You can request your data source owner to do it for you.
Doing it dax is painful and will cause memory and performance issues:
However, You can try this approach with DAX with UNION and SELECTCOLUMNS : https://stackoverflow.com/questions/50213905/is-it-possible-to-unpivot-in-power-bi-using-daxI have managed to do so using if sum & calculate but the result is constant and would not change as per any applied slicer but thanks a lot for reaching out (Y)