Merge columns, ignoring the distinct values

[Anonymous]

Hi,

I am currently trying to merge data from two tables.

There are four columns in table one and 1 column in table 2.

There are n number of values in all the columns. I have used DAX Summarize function on both the tables individually and average to calculate the average of each of the column based on the type.

I tried to use merge and append functions, only to fail because of duplication.

As seen in the image below, I want to use Assessment next to execution using the type of Table 1.

I am not able to do it because the type in both the tables in not unique, even when it has four types of variables. 

[amitchandak]

Check if this can help

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

else share sample data with sample output.

[Anonymous]

I would attempt to do this merge using Power Query as part of the import.  You can find a Merge Queries option in the Home area of the ribbon (far right).  You can also set the type of merge based on what information you want to keep (known as joins).