topic Re: Filtering based on date range. in DAX Commands and Tips

Filtering based on date range.

bob57 — Sat, 31 Oct 2020 18:23:45 GMT

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]

Re: Filtering based on date range.

mahoneypat — Sat, 31 Oct 2020 19:18:48 GMT

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

Regards,

Pat

Re: Filtering based on date range.

Fowmy — Sat, 31 Oct 2020 19:26:02 GMT

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

Re: Filtering based on date range.

bob57 — Sat, 31 Oct 2020 19:35:07 GMT

A perfect solution! Thank you so much!

Bob

Re: Filtering based on date range.

bob57 — Sat, 31 Oct 2020 19:36:27 GMT

A fine alternate solution. Thank you very much!

Bob

Re: Filtering based on date range.

Fowmy — Sat, 31 Oct 2020 19:39:19 GMT

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

Re: Filtering based on date range.

bob57 — Sat, 31 Oct 2020 19:54:39 GMT

Done, thank you!