Trying to create metrics for a Finacially Complex ARR Bridge

Hey All, 

I am trying to create the following measures in an ARR Bridge tab for some complex Financial Analysis: 

1. Opening - opening ARR in the period i.e. for FY22 - Jun-21 ARR, FY23 - May-22 ARR and LTM Nov-23 - Nov-22 ARR.
2. Lost Customer - Opening ARR for a customer that no longer generates revenue in a given period.
3. Downsell - the difference between the opening and closing ARR when a customer generates less revenue in a given period.
4. Gross Retention - Opening less Lost Customers Less Downsell.
5. Upsell - the difference between the opening and closing ARR when a customer generates more revenue in a given period.
6. Net Retention - Gross Retention plus Upsell.
7. New customer - Closing ARR for a customer that has generated revenue for the first time in a given period.
8. Closing ARR - Net Retention plus New Customer.

All of these have to be presented for FY 22, FY 23 and LTM 22-23 


Now I have a Revenue table that has Customer, Date, Revenue, ARR and some other fields. It also has a Fiscal Quarter and Year field derived from the date field.

This is the table:

How can I calculate the above measure in Dax? Are they too complex for PowerBI and should be taken to a SQL Stored procedure or can they possibly be achieved in PowerBI. Here is what the Table should look like:

Please guide on what should be the approach to solve this. Thanks