Forum Discussion
report level filter vs. filter on query
I have a Report Level Filter on a report on my CRM Salesorders, "Name does not contain Cancel". I want to change that so the filter is on the query itself, rather than on the report, but my values c...
Got it. Power Query is case sensitive. You have given does not contain "Cancel" so records with "Cancel" will filtered, but not "CANCEL". Please use the below formula to make sure all CANCEL/ Cancel gets filtered.
= Table.SelectRows(#"Changed Type", each not Text.Contains(Text.Upper ([Status]), "CANCEL"))
Could you please share what is the exact value in the column ( is it just 'Cancel' or value contains 'Cancel') and also share what filter you have used in Query level?
This is the report level filter
And this is the filter on the query:
Help will be much appreciated!