Opening Balance I am not getting the result..

[KashSam22]

I am working on a GL Table in which I am displaying Total Amount transaction wise or Account wise based on the Date Slicer and all transactions falling in the selected Date Range.. I also need to show Opening Balance which is sum of Total Amount before the Start date of the Slicer. 

I have created a measure as Opening Balance and following DAX but it is not giving me the desired output

Opening_Bal = Var OpenDate = [SelStartDate]

RETURN          

CALCULATE (SUM ('BCIA - APIGLEntry'[Total Amount]),

           REMOVEFILTERS('Calendar_BC'[Date]), REMOVEFILTERS('BCIA - APIGLEntry'[postingDate]),

           FILTER('BCIA - APIGLEntry', 'BCIA - APIGLEntry'[postingDate]<OpenDate))

Filter Statement is not working... If I remove Filter statement the Sum of all the transactions are coming correctly.. Can someone Help... SelStartDate is the first date of the Date Slicer

[Anonymous · Accepted solution]

Hi @KashSam22,

It seems like a common date range (defined by multiple date fields) analysis requirements. Perhaps you can take a look at the following link start date, end date analysis part if these helps:

Before You Post, Read This: start, end date 

Regards,

Xiaoxin Sheng