Forum Discussion
Filter between effective dates
Hello, Should I expect slow query response times when filtering an imported table with a dynamically selected date where it falls between row effective start and end dates? The link below contains a...
The Italians have some great videos on how to refactor queries to reduce cardinality. Apply filters first that have the biggest impact, then apply the other filters sequentially.
Instead of FILTER() try using CALCULATETABLE() . Use DAX Studio to watch for the number of records in each query plan.
Thanks for the reply. I've been enjoying their videos already...feels like I've tried it all!