Help with calculated column in PBI

I need to calculate actuals in Power BI (I TIPYCALLY USE EXCEL WITH PIVOTS), to calculate actuals this is the logic: Take the value in the intersection of Period 2023Q2, cycle 2023Q2 in source 1 Take the value in the intersection of Period 2023Q1, cycle 2023Q2 in source 2 Take the value in the intersection of Period 2022Q4, cycle 2023Q1 in source 2 Take the value in the intersection of Period 2022Q3, cycle 2022Q4 in source 2 Take the value in the intersection of Period 2022Q2, cycle 2022Q3 in source 2 Take the value in the intersection of Period 2022Q1, cycle 2022Q2 in source 2, etc

Source 2 has 14 cycles and 26 periods (14 for history and 12 for forecast)
Source 1 has only 1 cycle (current or latest) and 14 periods (all of them history)

The source data has also other 5 'sources' or models with information but to get data I need only those 2, so actuals for all 7 sources need to be the same as the logic explained above

I need this to be done in a dynamic way because every quarter I get new data so the cycles will update and the periods as well for all sources, however the structure won't. Source 1 will still have 1 cycle and 14 historical periods, all the other sources will have 14 cycles and 26 periods (14 history and 12 forecast)

any advice helps, I've tried chat GPT but I have gotten nowhere