Forum Discussion
AndrejZitnay
Post Patron
Post PatronHelp with openning and closed balance
Hello all, Would you be so kind and help me out with openning and closed balances? I have 4 measures from 3 tables and 1 merge date table for months. I struggle to find solution for openning...
AndrejZitnay , One month less should do
Opening balance = CALCULATE([All measure ],filter(allselected(Table),Table[Date] <=maxX(Table, dateadd(Table[Date],-1, month))))
amitchandak
Super User
Super UserAndrejZitnay , One month less should do
Opening balance = CALCULATE([All measure ],filter(allselected(Table),Table[Date] <=maxX(Table, dateadd(Table[Date],-1, month))))
Hi, I applied to my problem but i faced dependency problem. You use filter so i wrote my calculated closing balance (that depends on opeing balance with formulas) to a table as calculated column and try to find opening balance