Hi All,
I currently have multiple tables of survey data. One surevey have all questions, and then other surveys only have one part of the question, so only the relevant survey is provided to a client. In my report, i would like a table where i can have the survey specific score with the survey with all the questions in one column, as it is now, when i put the scores in a table, they appear in two different tables due to being on seperate surveys.
Example:
| Table 1 | | | | | Table 2 | | | Table 3 | | | Table 3 | |
| Survey | Score1 | Score 2 | Score3 | | Survey | Score1 | | Survey | Score 2 | | Survey | Score 3 |
| 1 | 5 | 5 | 5 | | 2 | 3 | | 3 | 4 | | 4 | 5 |
| 1 | 6 | 2 | 4 | | 2 | 6 | | 3 | 5 | | 4 | 6 |
| 1 | 4 | 3 | 4 | | 2 | 5 | | 3 | 6 | | 4 | 7 |
| 1 | 3 | 4 | 3 | | 2 | 3 | | 3 | 7 | | 4 | 4 |
| 1 | 3 | 6 | 2 | | 2 | 4 | | 3 | 3 | | 4 | 4 |
| 1 | 4 | 3 | 3 | | | | | | | | | |
| 1 | 5 | 2 | 5 | | | | | | | | | |
| 1 | 6 | 3 | 8 | | | | | | | | | |
| 1 | 4 | 4 | 7 | | | | | | | | | |
In the first table, i would like to only have have score 1 from both survey 1 and 2, with the option to filter to only look at survey 1 or 2 data (Which i have that part). Is there a DAX function that will allow me to have a table where score 1 data from table 1 and 2 to be under one column. (And the same for score 2 and 3). So the table would look like this:
| Table | |
| Survey | Score 1 |
| 1 | 5 |
| 1 | 6 |
| 1 | 4 |
| 1 | 3 |
| 1 | 3 |
| 1 | 4 |
| 1 | 5 |
| 1 | 6 |
| 1 | 4 |
| 2 | 3 |
| 2 | 6 |
| 2 | 5 |
| 2 | 3 |
| 2 | 4 |
Thank you.
