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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Jiang_Yue
Frequent Visitor

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
v-jingzhan-msft
Community Support
Community Support

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
Super User
Super User

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.


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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors