cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bhorvati Frequent Visitor
Frequent Visitor

How Remove Duplicates Using SELECTCOLUMNS

How would I modify this formula to remove duplicates for Material Number?

 

New Table Name = SELECTCOLUMNS(Existing Table Name,  "Material Number",[Material Number], "Material Name",[Material Name])

 

I have an existing table and I am creating a new table from 3 fields in the existing table.   I think SELECTCOLUMNS is the DAX formula I should be using since these are all just text fields, but I want to remove duplicates for Material Number.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: How Remove Duplicates Using SELECTCOLUMNS

Hi @bhorvati

 

One way is just to wrap a DISTINCT around it

 

 

New Table Name = 
DISTINCT(
SELECTCOLUMNS(Existing Table Name, "Material Number",[Material Number], "Material Name",[Material Name])
)

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

1 REPLY 1
Highlighted

Re: How Remove Duplicates Using SELECTCOLUMNS

Hi @bhorvati

 

One way is just to wrap a DISTINCT around it

 

 

New Table Name = 
DISTINCT(
SELECTCOLUMNS(Existing Table Name, "Material Number",[Material Number], "Material Name",[Material Name])
)

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,802)