Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
I want to return a column if their corresponding criteria has been met, for example;
Name | 2019 Sales | 2018 Sales | Sales Growth |
Apple | 1,365,386.00 | 1,425,704.00 | -4.23% |
Orange | 1,913,488.00 | 2,116,739.00 | -9.60% |
Grape | 697,523.00 | 691,203.00 | 0.91% |
Dog | 979,273.00 | 1,097,049.00 | -10.74% |
Cat | 1,751,316.00 | 1,441,230.00 | 21.52% |
Fox | 3,228,354.00 | 3,144,902.00 | 2.65% |
I only want to filter names whose sales growth were positive which is computed and not included in the database.
hope you can help me with this one.
Solved! Go to Solution.
Hi @ryan0521
If you need to filter rows which Sales Growth >0, only keep rows which Sales Growth <=0,
Open edit queries, select "Less than or equal to"
Or in Data model,
Or create a column, then filter out rows=0,
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ryan0521
If you need to filter rows which Sales Growth >0, only keep rows which Sales Growth <=0,
Open edit queries, select "Less than or equal to"
Or in Data model,
Or create a column, then filter out rows=0,
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much @v-juanli-msft , but is there a way I can filter it out in REPORT?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.