Forum Discussion
Solved
Filtering based on date range.
Good day! This seems pretty simple, but the solution escapes me. As currently designed, I can click on a project in the 'Top Level Project View' table and all tasks for that project will appear in t...
Highlight your project tasks visual and, on the Filter Panel for this visual, select Relative Date filter and enter next 14 days.
Regards,
Pat
A perfect solution! Thank you so much!
Bob
bob57
Create a measure and assign it to the visual as 1
You can download the file: HERE
Next14Days =
IF( SELECTEDVALUE('Project Tasks'[StartDate]) > (TODAY() + 14) , 0 , 1 )
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
A fine alternate solution. Thank you very much!
Bob