I have tried so many things in excel to get data to look like this, so i could load it into power bi, and with small amount of data excel can do the trick, but my man you just saved my ass at work. Thank you so much for this. :)
Can you think of a scenario where you might use Unpivot Only Selected Columns in Power BI? I thought about it a lot, but I cannot come up with a real life scenario where this would be helpul. Anyway, you did a great job in explaining the differences. Thank you!
That's a really good question, I think there can be some scenarios but it all depends on what can happen to the underlying data, in the example use case I had somebody could add a subcategory to the file. Another case could be where we have a file per year and months as the headers, we would only want to unpivot the months in this case.
I have tried so many things in excel to get data to look like this, so i could load it into power bi, and with small amount of data excel can do the trick, but my man you just saved my ass at work. Thank you so much for this. :)
Fantastic, glad I could help.
Can you think of a scenario where you might use Unpivot Only Selected Columns in Power BI? I thought about it a lot, but I cannot come up with a real life scenario where this would be helpul. Anyway, you did a great job in explaining the differences. Thank you!
That's a really good question, I think there can be some scenarios but it all depends on what can happen to the underlying data, in the example use case I had somebody could add a subcategory to the file. Another case could be where we have a file per year and months as the headers, we would only want to unpivot the months in this case.
Amazing! Thank you very much!
I like your explanation man
I appreciate that!
Thank you!
Nice explanation