why CLOSINGBALANCEMONTH doesn't work if I use any filter?

[abinashphuel]

I used following DAX formula to calculate the closing balance by month:
ClosingBalanceMonth = CLOSINGBALANCEMONTH(SUM(GeneralLedgerEntries[Amount]),Dates[Date])
It gives the correct result.

But as soon as I add date filter, it didn't display the result.

[amitchandak]

@abinashphuel , Hope month and year are coming from Date table . and there data on the last date of that month

You can also check lastnonblankvalue

Power BI closingbalancemonth closingbalancequarter closingbalanceyear, lastnonblankvalue- Closing Balance, Distibutre Target: https://youtu.be/yPQ9UV37LOU

I am getting data