Circular dependency in DAX

Hi Robin96 ,

Thank you for reaching out to the Microsoft Fabric Community. I implemented your scenario, and I was able to achieve the expected results as per your requirements. Please review the output.
Result:

Used Measure:

Cash_T = 
VAR CurrentMonth = MAX('Table'[Date]) 
VAR PrevMonthCash = 
    CALCULATE(
        MAX('Table'[Cash (t)]), 
        FILTER(
            ALL('Table'),
            'Table'[Date] = EOMONTH(CurrentMonth, -1)  // Get last month's Cash_T1
        )
    ) 
RETURN
IF(
    MONTH(CurrentMonth) = 1, 
    MAX('Table'[Cash (t)]),  // Keep the initial cash balance for January
    PrevMonthCash
)

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.