Forum Discussion
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 specific task. However, I want to display ALL tasks in a grid from all plans. For example, I have a task that has a training start date. I will filter on tasks that have a training start date in the next two week. I want my grid to show all tasks from the plan, regardless of whether or not all tasks have a date. Right now, the only thing that's displaying in my grid are tasks that have a due date, it's now showing tasks that don't have a due date.Visual of dashboard
1 Reply
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.
