Combining Tables so two columns become one for a table

[TBSST]

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. 

[barritown]

Hi @TBSST,

You would want to master the DAX function UNION and create a new table using it.

In plain text:

New Table = 
UNION ( 
    SELECTCOLUMNS ( Table1, "Survey", [Survey], "Score1", [Score1] ),
    Table2 )

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian