Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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.
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
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.