How to convine fields in one table?

Hi Anonymous,

You have two ways to do it, you can do it on Dax using DISTINCT(UNION(SELECTCOLUMNS('Table1',"Nameatyourchoice",[Column]),SELECTCOLUMNS('Table2',"SAMENAMEASBEFORE",[Column]),...))

Or you can go to the Query Editor, append all of them and then Remove Duplicates.

Let me know if it worked, if so mark as solution.

BR,

DR

Hi Anonymous ,

If I understand you correctly, you can refer to thes videos:

Excel Power Query #06: Import Multiple Excel Files From Folder Into One Excel Table or Data Model.

Remove Duplicate Data Power BI.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.