Forum Discussion
Creating an opening and closed table - members
Hi viralpatel21 ,
Could you please provide some sample data for table contacts, FeeDate & au_subscriptions and information about their relationships? The screenshot is a bit blurry, so I can't see it clearly. Also, please provide the logic for calculating the opening balance and closing balance.
Opening balance=?
Closing balance=?
I found some links that calculate opening balance and closing balance. You can refer to them to get the results you want.
DAX Closing and Opening Balances
Opening Balance DAX | Closing Balance DAX
Closing and opening balance with cashflow
Best Regards
Hi Anonymous
Thank you for replying to my query. It will be very difficult in providing a sample size for contacts table and au_subscription. However the FeeDate table has got 2 column: Date and Months
Date = Every date from 1st of jan 2020 till today in the format of 01/01/2020
Months: just for each date what the month is i.e. 01/01/2021 = Jan20
I beleive my opening and closing balance is wrong but this is what i want to acheive:
Opening balance = This should be the closing balance of the previous month. i.e:
Jan closing balance is 9010, then Feb opening balance is 9010
| Month | Jan | Feb | Mar |
| Opening balance | 8914 | 9010 | 9230 |
| Active Registration | 193 | 2010 | 1541 |
| Active Subscription | -102 | -1790 | -1290 |
| Closing balance | 9010 | 9230 | 9481 |
Closing balance = Opening balance of the month + Active registration - Active Subscription
Hopefully this made some sense.
thanks
viral