Forum Discussion
Return a column if a computed column met the criteria
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.
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
MaggieCommunity 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.
3 Replies
v-juanli-msftCommunity Support
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
MaggieCommunity 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?
- v-juanli-msft
