Return a column if a computed column met the criteria

[ryan0521]

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.

[v-juanli-msft · Accepted 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.

[v-juanli-msft · Accepted 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.

[ryan0521]

Thank you so much @v-juanli-msft , but is there a way I can filter it out in REPORT?

[v-juanli-msft · Accepted solution]

Hi @ryan0521 

Yes

You could filter it by filter pane

Best Regards
Maggie