Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

How can I keep only first rows

Hello All!

 

I have a table with 9 columns. In those columns some data are duplicated, in some columns not. How can I keep only first rows of  different data? for example, what I have:

DepAI #AI NamePlanned startActual startPlanned EndActual EndWeigthed AverageStatus
SalesP1Instruments5/1/20245/1/20247/7/20247/7/2024100%100%
TrainingP2Log On Book3/1/2024 3/1/20245/31/20245/31/2024100%16,5%
TrainingP2.1A4 Paper3/1/2024 3/1/20245/31/20245/31/202450%33%
TrainingP2.2Materials3/2/20248/2/202431/2/202415/3/202450%0%

 

what I want to see:

DepAI #AI NamePlanned startActual startPlanned EndActual EndWeigthed AverageStatus
SalesP1Instruments5/1/20245/1/20247/7/20247/7/2024100%100%
TrainingP2Log On Book3/1/2024 3/1/20245/31/20245/31/2024100%16,5%
1 ACCEPTED SOLUTION
BA_Pete
Super User
Super User

Hi @Anonymous ,

 

I think there's two ways to achieve this based on the sample data provided:


-1- Select the [Dep] column then go to the Home tab > Remove Rows (dropdown) > Remove Duplicates. This should remove every instance of [Dep] after the first value encountered from the top of the table. This will rely on the table sorting being correct to ensure the instance of each [Dep] you want to keep being highest in the table.

 

-2- Select the [AI #] column then the dropdown to the right of the column header then go to Text Filters > Does Not Contain... . In the dialog that opens, enter "." (with no quotations) into the 'Enter or select value' box. This will filter all rows that have a duplicated [AI #] value, but relies on the system always assigning '.1', '.2' etc. to the end of the [AI #] values when they are duplicated.

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




View solution in original post

2 REPLIES 2
BA_Pete
Super User
Super User

Hi @Anonymous ,

 

I think there's two ways to achieve this based on the sample data provided:


-1- Select the [Dep] column then go to the Home tab > Remove Rows (dropdown) > Remove Duplicates. This should remove every instance of [Dep] after the first value encountered from the top of the table. This will rely on the table sorting being correct to ensure the instance of each [Dep] you want to keep being highest in the table.

 

-2- Select the [AI #] column then the dropdown to the right of the column header then go to Text Filters > Does Not Contain... . In the dialog that opens, enter "." (with no quotations) into the 'Enter or select value' box. This will filter all rows that have a duplicated [AI #] value, but relies on the system always assigning '.1', '.2' etc. to the end of the [AI #] values when they are duplicated.

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Anonymous
Not applicable

Hi @BA_Pete ,

 

Wow, thank you so much, for reference I've used 2nd option and it did work well. Thank you!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.