How to convine fields in one table?

[Anonymous]

Hello everyone,

My doubt is, i have 6 fields imported from excel to power bi, each one is for a different user, in power bi i summarize these reports from each user, but i need to make a summary of the entire area, the base excel from every user is the same, but with different data introduced by the users, i need to make a table that counts monthly the amount of data introduced by the users, but avoiding dupplicated data to increase the count number (each user introduces different data but the base have already previus data that repeats in every user),
Thanks for reading and for your atention.

[Anonymous · Accepted solution]

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

[Icey · Accepted solution]

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.

[Anonymous · Accepted solution]

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