Getting Last row between two dates

[Laveezai]

Hello, here's my problem:

I have a table that logs each change to an Actual YTD. It includes the number, the attached project and the date the record was created.

I also have a table containing custom quarters on which I need to focus my analysis.

I'd like to be able to filter my Actual YTD table to retrieve only the last row of quarters 1, 2, 3 and 4.

For the moment, I'm not sure how to do this, as I first need to make the link in my model between my Actual YTD History table and my closing dates table.

I've made a link between  created on --- end date .

Do you know how to proceed?

[Ahmedx]

you need read about of Slowly Changing Dimensions in Power BI