cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jcastr02
Post Prodigy
Post Prodigy

Filtering out rule

I have two queries    Query A - Contains Employee ID, and Employee Title     Query B - Contains B contains the Employee ID, but as one of the final applied steps, I use grouping and Employee ID is not one of the items grouped by.  I'd like to filter out any records where the employee Title is function lead.  Is there a way to insert a step to filter this out?   Ex below + picQueryB.png

 

Employee IDEmployee Title
123456Technician
765432function lead
123344Technician
222222function lead
999999Technician
  
Query A 
1 ACCEPTED SOLUTION
ryan_mayu
Super User II
Super User II

@jcastr02 

maybe you can try merge tables before the group step and filter out the values you don't want.

1.PNG2.png3.png





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

4 REPLIES 4
ryan_mayu
Super User II
Super User II

@jcastr02 

maybe you can try merge tables before the group step and filter out the values you don't want.

1.PNG2.png3.png





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

amitchandak
Super User IV
Super User IV

@jcastr02 , Check if Table.SelectRows can help

https://docs.microsoft.com/en-us/powerquery-m/table-selectrows



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

@ryan_mayu @amitchandak Is there a way to add a employee Title column in Query B based off of data that is column A, sort of like a vlook in Excel so that I can populate the employee title in Column B using M?

@jcastr02 , you can use merge in Power Query/M

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

 

In Dax you  have the following way - check my video https://www.youtube.com/watch?v=czNHt7UXIe8



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors