Trouble with DAX to calculate YTD by Quarter with specific rules

[Laveezai]

My problem is as follows:

I have facts table containing Actual YTDs entered at each quarter.

This table is composed of the following fields:

Actual YTD (int) | Date (DateTime of creation) | Project Code (Text) | Quarter (Text -> Q1 2024, etc.)

I'd like to sum up the values for each quarter, but the problem is that within a quarter, a project doesn't necessarily have a new Actual YTD, and each Actual YTD entered by Quarter represents the cumulative total of the previous Quarter and the current Quarter.

However, I'd like to retrieve the most recent Actual YTD before that quarter, if it doesn't have an Actual YTD.

I'm having trouble thinking about creating a measure to solve this problem. Could you help me?

Thanks in advance

[Ritaf1983]

Hi @Laveezai 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523