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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

query and Filter out different sets of data under different situations

When I'm doing the Power query, is there any method similar to If condition to do the following actions:

1. If the data less than 4, then I filter out this set of data as query results

2. If the data larger or equal to 4, then I filter out another set of data as query results

3. Under different situations I use different data to make queries as I'll link with Power Automate for later use. 

2 REPLIES 2
Anonymous
Not applicable

Hi @Anonymous 

 

Is it expected to happen when filtering rows in a table or querying data from the data source? The answer may be different due to different data sources and different requirements. Can you provide some more details to describe the scenario? Using some dummy sample data and expected result will help us understand your requirement better. 

 

Best Regards,
Jing

dufoq3
Super User
Super User

Hi @Anonymous, yes it is possible. If you want to know more, provide sample data as table (not a screenshot) and expected result based on sample data.


Note: Check this link to learn how to use my query.
Check this link if you don't know how to provide sample data.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors