Opening Balance I am not getting the result..

KashSam22 — Wed, 26 Jul 2023 11:30:04 GMT

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

Re: Opening Balance I am not getting the result..

Anonymous — Fri, 28 Jul 2023 02:54:08 GMT

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

topic Re: Opening Balance I am not getting the result.. in DAX Commands and Tips

Opening Balance I am not getting the result..

Re: Opening Balance I am not getting the result..