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
