Forum Discussion
Alternative to split/unpivot?
So I have a table (googlesheets) from a research with multiple questions, and many questions have multiple answers separated by commas. It's quite extensive, there are like 20 questions and each one ...
Hi ViniciusLeyro ,
In this case the best option is the one you are using since this allows the flexibility to make your anilisys. Power BI have no issues with the additional lines on your model, only question that can happen is the time to refresh but this depends on the source and your licensing.