How to convine fields in one table?

Question

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 Answer

Hi&nbsp;Anonymous,&nbsp;You have two ways to do it, you can do it on Dax using DISTINCT(UNION(SELECTCOLUMNS('Table1',"Nameatyourchoice",[Column]),SELECTCOLUMNS('Table2',"SAMENAMEASBEFORE",[Column]),...))&nbsp;Or you can go to the Query Editor, append all of them and then Remove Duplicates.&nbsp;Let me know if it worked, if so mark as solution.&nbsp;BR,DR

Forum Discussion

How to convine fields in one table?

2 Replies

Related content

Displaying Table Fields as Rows in DirectQuery

SUMMARIZE, VALUES, and other table generation/manipuation with field parameters

Custom Date table based on date field in FACT table with hierarchy applied to datetime field

Using Field Parameters to Alter My Table Visual Content

Field Parameter Question