Finding the project status at the time when date changes are made

[Rondel]

Hello,

I have two tables that pull history of a project.

• Table 1: Target End Date Field - shows the date/time when that field was changed
• Table 2: Project Status - shows the date/time when the project changed statuses (Definition, Discovery, etc.)

I provided an image below to hopefully explain this better, but what I needed help on was trying to see if there is a way to find the status of the project at the time the target end date field was changed.

For example, the image I attached below shows the target end date field was changed on 5/16/2024.  I wanted to create a column to show that during this time, the project status was in Implementation (the project entered Implementation status on 2/27/2024 and didn't transition out until 9/11/2024.) - Thank you for your help!

[some_bih]

Hi @Rondel so you want "previous" date time or just date status for some project?

I hope you have Date / Calendar table in your model

[Rondel · Accepted solution]

Hey @some_bih  - thanks for your reply.

I actually was able to find a solution using this link here: 

https://stackoverflow.com/questions/76409698/power-bi-find-value-associated-with-closest-date-in-dax