topic why CLOSINGBALANCEMONTH doesn't work if I use any filter? in DAX Commands and Tips

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

abinashphuel — Mon, 16 Jan 2023 20:01:17 GMT

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.

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

amitchandak — Tue, 17 Jan 2023 01:38:07 GMT

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