Filtering based on date range.

[bob57]

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 the 'Task Starts foe Next 14 Days' table. I only want to see tasks that will start over the next 14 days. Here is a ink to the .pbix, if helpful: https://1drv.ms/u/s!Agkx6hQs0NiX1jVhOSd6FFATlSP3?e=SLnAJt.

Thank you for your time and effort.

Bob

Data Model: 'Projects'[Id] ----> 'Project Tasks'[ProjectId]

[mahoneypat · Accepted solution]

Highlight your project tasks visual and, on the Filter Panel for this visual, select Relative Date filter and enter next 14 days.

Regards,

Pat

[Fowmy]

@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 🙂

YouTube  LinkedIn

[bob57]

A fine alternate solution. Thank you very much!

Bob

[Fowmy]

@bob57 

Glad it worked, you can accept more than one solution.

________________________

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 🙂

YouTube  LinkedIn

[bob57]

Done, thank you!

[mahoneypat · Accepted solution]

Highlight your project tasks visual and, on the Filter Panel for this visual, select Relative Date filter and enter next 14 days.

Regards,

Pat

[bob57 · Accepted solution]

A perfect solution! Thank you so much!

Bob