Forum Discussion
Why doesn't REMOVEFILTERS work?
I have a simple formula that calculates the incident count per month, which is then broken down by our defined week of the month (all months have W1, W2, W3, & W4). Works great. Avg Count per m...
daXtreme
Solution Sage
Solution SageIf you have a date table, then probably your Year Month Name column is sorted by another column, right? If that's the case, you have to remove the filter not only from the field itself but also from the field by which the field is sorted. To see what happens in your code you can use the Analyzer built in to Power Query. Extract the query and see what happens in there. I'm relatively sure it's to do with the sorting field.