Forum Discussion
Creating connection between 3 survey score tables from different teams, but the same questions/date?
I'm very new to Power BI and I'm analyzing survey data.
There are 3 groups: Group A, Group B, and Group C.
There are 15 different questions.
These questions were asked to the same group in Jan, Feb, and March.
I have a Group A table, Group B table, and Group C table.
I think I'm having trouble modelling the data correctly (probably overcomplicating it).
I try to plot a line graph with small multiples of the "question", "month" as the axis, and "score" as the values, it just doesn't turn out right and I also want to label them by the "groups" and cannot do so.
Any assistance on where my mistakes are?
Anonymous , Either add a group name column in three table in power query and Append
Append : https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Or create common dimensions like month and questions
2 Replies
- amitchandak
Super User
Anonymous , Either add a group name column in three table in power query and Append
Append : https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Or create common dimensions like month and questions
Hi Anonymous,
I'd like to suggest you create a new calculated table to union these table records with a custom field to remark the source table.
New table = UNION ( ADDCOLUMNS ( GroupA, "Source", "GroupA" ), ADDCOLUMNS ( GroupB, "Source", "GroupB" ), ADDCOLUMNS ( GroupC, "Source", "GroupC" ) )Regards,
Xiaoxin Sheng