Forum Discussion
Post PatronHelp with openning and closed balance
AndrejZitnay , One month less should do
Opening balance = CALCULATE([All measure ],filter(allselected(Table),Table[Date] <=maxX(Table, dateadd(Table[Date],-1, month))))
Super UserAndrejZitnay , I am hoping you are using a common date table
Sum of all the measures other then opening balance
All measure = [Measure from Table 1] + ....
Closing balance = CALCULATE([All measure ],filter(allselected(Table),Table[Date] <=max(Table[Date])))
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
Post PatronHello amitchandak
You are star.
I have my closing balance now.
How I can get opening balance?
I know that it should be closing balance from last month.
Thanks.
Andrej
- amitchandak
AndrejZitnay , One month less should do
Opening balance = CALCULATE([All measure ],filter(allselected(Table),Table[Date] <=maxX(Table, dateadd(Table[Date],-1, month))))
- AndrejZitnay
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
