Need help with time intelligent dax

visitprateek 

I added a dates table as it supports time intelligence functions and it will be useful for your model, you may extend it with additional columns for various uses. 

Create the following measures:

Total Amount = SUM(Data[Amount])

Opening Balance - Year = 
VAR __CurrDate = MAX('Dates'[Date])
VAR __Result = 
    IF( [Total Amount] <>BLANK(), 
            CALCULATE(
                [Total Amount],
                MONTH( 'Dates'[Date] ) = 12, 
                YEAR('Dates'[Date]) < YEAR( __CurrDate)
            )
    )
RETURN
    __Result

Closing Balance - Qtr End = 
[Opening Balance - Year] + [Total Amount]

File is attached