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

Power Query filtering rows with conditions

Hi,

 

I have a database with information of different employees in diferent companies. What i would like to do is for each company id i would like to only stay with the row that contains the information of the Chief, but if there is no chief I want to keep the Representative Legal. There is a column that says which categorie is the employee (if it's chief, representative legal, manager, etc.).

 

 Do you know how can I do this? Maybe by adding a custom column that says if it's the row that stays or not?

1 REPLY 1
Vijay_A_Verma
Super User
Super User

Can you post your table with some dummy data?

How to provide sample data

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.