Forum Discussion
Opening balance calculation
Hi, I am trying to calculate opening balance for each month from my available data. I have also added a slicer for month to see the opening balance for selected month. I have used following formu...
Hi Anonymous,
Could you have tried with a measure instead of a calculated column? Or you could use the OPENINGBALANCEMONTH function to have a try. If the problem still persists, could you please offer a sample file to have a test and post your desired result if possible?
Regards,
Daniel He
https://drive.google.com/open?id=1i3MMEhFoJEGX6KMouRk9nMgNJWaFGwyX
Hi v-danhe-msft,
Attached is the link to the test file. I need my opening balances to be divided betweent the sources, however i get the total across all data sources. How to make that change?
Thanks