query and Filter out different sets of data under different situations

[Jiang_Yue]

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. 

[v-jingzhan-msft]

Hi @Jiang_Yue 

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]

Hi @Jiang_Yue, 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.