Forum Discussion
Data Modelling Best Practice for Survey
I couldn't post as I'm getting an invalid HTML error.
<p>As I'm new to data and power BI, I'm dont know some of the keywords to search for the solution effectively.<br />Sample of the radiobutton and textbox questionaires:</p>
<p><span style="font-family: inherit;"><li-image width="999" height="289" alt="radio.PNG" align="inline" id="446305i93FC1F7B54C7FA93" size="large" sourceType="new"></li-image><br />Sample of the checkbox questionaires:</span></p>
<p><li-image width="999" height="176" alt="checkbox.PNG" align="center" id="446304i355E941214BAEB87" size="large" sourceType="new"></li-image><br /><br /></p>
The checkboxes (top) and radiobutton/textbox questionaires are shown as above.
- amitchandak5 years agoSuper User
Anonymous , if it is not too much data I would prefer to unpivot.
https://radacad.com/pivot-and-unpivot-with-power-bi
That will give in questions in row