Merge columns, ignoring the distinct values

Question

Hi,&nbsp;I am currently trying to merge data from two tables.&nbsp;There are four columns in table one and 1 column in table 2.&nbsp;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.&nbsp;I tried to use merge and append functions, only to fail because of duplication.&nbsp;As seen in the image below, I want to use Assessment next to execution using the type of Table 1.&nbsp;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.&nbsp;&nbsp;

anonymous · Answer

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

amitchandak · Answer

Check if this can helphttps://radacad.com/append-vs-merge-in-power-bi-and-power-queryelse share sample data with sample output.&nbsp;

Forum Discussion

Merge columns, ignoring the distinct values

2 Replies

Related content

Distinctive Count across two columns

Rankx ignoring 1 column

Does DISTINCT not ignore BLANK values anymore?

count distinct

distinct count of multiple columns