Forum Discussion

AndrejZitnay's avatar
AndrejZitnay
Icon for Post Patron rankPost Patron
5 years ago
Solved

Help 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...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    AndrejZitnay , One month less should do

     

    Opening balance = CALCULATE([All measure ],filter(allselected(Table),Table[Date] <=maxX(Table, dateadd(Table[Date],-1, month))))

AndrejZitnay's avatar
AndrejZitnay
Icon for Post Patron rankPost Patron
5 years ago

Hello 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's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

AndrejZitnay , One month less should do

 

Opening balance = CALCULATE([All measure ],filter(allselected(Table),Table[Date] <=maxX(Table, dateadd(Table[Date],-1, month))))

  • mehmet's avatar
    mehmet
    Frequent Visitor
    5 years ago

    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