Only apply Events in Progress if start date is before another date.

[64653463456greg]

I have a timeline with events in progress.

I've created a measure with said events in progress.

What I'd like to happen now is I only want to see the events in progress based on whether the start date of the event falls before another date or not.

Example:

The start date of the event in progress is 2024-03-01 with an end date of 2024-06-01.

I only want to show that event in progress in my report IF the start date is before a third date, let’s say 2025-01-01.

See picture:

If “Expected Due Date” is before “Date of Decision, then allow the “Events in Progress-measure” to show that event in the timeline.

Any and all help in the matter is greatly appreciated.

[Anonymous]

HI @64653463456greg,

According to your description, it seems like a common multiple date fields range analysis requirement. Perhaps you can take a look at the following blog 'star date', 'end date' parts if it helps:

Before You Post, Read This - Microsoft Power BI Community

Regards,

Xiaoxin Sheng

[amitchandak]

@64653463456greg , check if you need somthing similar

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[64653463456greg]

Thank you @amitchandak for your reply, but from what I can see the link you provided does not help me in my quest.

If you have another solution or if you can elaborate as to which part of the provided link you think might help me with my problem, that would be greatly appreciated.

Thank you!