Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Jacob Birk]

I have a set of data containing one column with IDnumbers, another with some categories 

E.G. 
IDnumbers                        Categori
1001                                 Carrot
1002                                  Apple
1002                                 Orange
1007                                 Apple
1009                                 Carrot
1011                                 Carrot
1011                                 Orange
1014                                 Carrot

I would like to eliminate all the data where the ID number occurs only once and keep all the datalines from ID’s that have more lines. 

How do I approch this?

——————————
Jacob Birk
——————————

[Aurelien BETBEUI KWANDJEU]

Hello Jacob,

load data in power bi and group it by IDnumbers, create indicator that count the number of IDnumbers and add another column to complet the categori.

After do that develop column categori and filter data with Nombre = 1

Thanks you,

——————————
Aurelien BETBEUI KWANDJEU
CHIEF DATA OFFICER (BI & DWH)
——————————
——————————————-

[Ben Howard]

Hi, To compliment Aurelien’s excellent answer, I’ve added a screen shot in English in case your French isn’t too good.   Also, I’ve added a couple of additional steps in the query editor.  i)  Filter where the number of columns is > 1 and ii)  remove the columns you don’t need.   I’ve also uploaded the .pbix file I created so you should be able to follow the steps.

——————————
Ben Howard
Warrington
——————————
——————————————-

[ganesh kumar]

Hi

please find the attachment.

i have created the new column to find duplicate, used in slicer .

 

?

——————————
ganesh kumar
Business Analyst
9500990994
——————————
——————————————-

[Tim Dyeson]

Hi Jacob,

One other approach is this: In the Query Editor window, select the ID column and use the Keep Rows button and select Keep Duplicates. 

Tim

——————————
Tim Dyeson
Performance Measurement Manager
——————————
——————————————-