Get new table containing unique values from existing table.

[tomsuare]

Hello Everyone I have a dataset that looks like this and want to get a table containing only unique values. 

Employee ID	Company Worked
123	CompanyCars
345	CompanyCars
678	CompanyBus
123	CompanyAircrafts

And the goal is to get unique values in another table that looks like this either by using power query or dax: 

Employee ID	Company Worked
123	CompanyCars
345	CompanyCars
678	CompanyBus

[FreemanZ · Accepted solution]

hi @tomsuare 

try to create a calculated table like:

table = 

ADDCOLUMNS(

   VALUES(TableName[Employee ID]),

   CALCULATE(MAX(TableName[Company Worked]))

)

[Ashish_Mathur]

Hi,

In the Result table, why have you chosen Cars over Aircrafts for Employee ID 123? 

[tomsuare]

Edited due to misstyping.

[Ashish_Mathur]

Your question is still not clear.  Do you want to keep the active rows or the inactive rows?  Take a larger dataset, explain the question in simple English and show the expected result.

[v-jingzhang · Accepted solution]

Hi @tomsuare 

Here is one option with Power Query. Use Group By feature. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[FreemanZ · Accepted solution]

hi @tomsuare 

try to create a calculated table like:

table = 

ADDCOLUMNS(

   VALUES(TableName[Employee ID]),

   CALCULATE(MAX(TableName[Company Worked]))

)