Forum Discussion
BeckyH1324
3 years agoFrequent Visitor
Date range filter
I don't know if this is possible, and I hope I can explain this properly. I am pulling my information from Microsoft Planner into an Excel spreadsheet. I want to have a date filter that looks at a sp...
GregMarbais
3 years agoKudo Collector
Hey BeckyH1324 that's because the date range excludes any null values. I think to do what you're doing, you'd need to come up with a measure that looks at each task to determine if it's within that date range or null. I've done it before where I created a Date Table that I let users use as a date range picker and that feeds into a measure that returns in-scope or out-of-scope (can be 1 or 0) then I use that measure to filter the table that I display. But the date table behind the date range picker can't be connected to the tasks table or it'll behave the same way it is now.