Forum Discussion
Convert One Row of Data into Multiple Rows
Hello, I've been working with Power Bi for a few months now; I have used the forums to find answers to my questions. Unfortunately, I have to make this post as I haven't been able to find a solutio...
Tallyski
Based on your question it did not realize it were that many groups and column. Not sure if that will work. The formula's will change but I doubt this is- the best solution on this data size.
You could consider making 4 different query's one for each group. Unpivot that group.
Then Append All the groups into one query.
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
Best regards,
Jeroen