Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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 @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
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!