Forum Discussion

niels_vngi's avatar
niels_vngi
Frequent Visitor
5 years ago

Restructure and pivot 'flat' survey data

Dear all,   Since I’m new to the Power BI community I think it is appropriate to start with a brief introduction. My name is Niels and I work for an international development organisation. The proj...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi

 

Sorry to disturb you.
Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.


Best Regards,
Stephen Tao

  • niels_vngi's avatar
    niels_vngi
    Frequent Visitor
    5 years ago

    Hi Stephen,

     

    Sorry for my late response. To be honest, the unpivoting is a step I already took and it works fine. The result however is that I will have to create lots of new (unpivoted) tables. I'm looking for people that have experience processing (survey) data with a similair flat structure. For example:

     

    • Are performance issues to be expected when referencing to the same base query with over 100 queries and 90.000 records in the base query?
    • Is my approach to create one table per survey question a solid one or are there better / faster / easier solutions

    Kindest regards,

     

    Niels