Running Totals in the Balance sheet

[AnilKumar]

Hi all,

I have a arequirement to write the DAX for the running totals in the Company BalanceSheet. where the 19-20 FY balance need to be added to 20-21 FY like this the subtotals also need to be added. I tried with the DAX

B3 = CALCULATE([B2],FILTER(ALL('MyGateDB'),'MyGateDB'[VoucherDate]<= MAX('MyGateDB'[VoucherDate]) && 'MyGateDB'[Ledger Name]=MAX('MyGateDB'[Ledger Name])))
But there was no entries to ledgers in 20-21FY so those are getting blanks .

Thaks in advance,

Vishnu Priya

[v-chuncz-msft]

@AnilKumar 

You may add condition below.

|| ISBLANK ( 'MyGateDB'[Ledger Name] )

[AnilKumar]

Hi @v-chuncz-msft ,

I  tried the your susggestion. but still, no data coming. Please see the below snap for the reference.

As i'm using a measure, it is checking with it's scope like in 20-21 FY. As there was no data (records) for some ldgers, it is showing like blank. Is there any alternate to achieve this running totals and subtotals?

Thanks & Regards,

Vishnu Priya