Opening and Closing Balances

DAX DAX Calculations
1

I am working on a report where I take the output of a financial template forecast and include it in PowerBI.

For the most part it is all fine and I have followed the financial reporting course and templates so that all of the data shows up in the right place

image
image1319×620 66.9 KB

My issue arises on the opening and closing cash balances.

In the actual data set that I am using I have the opening cash for each weekly period however the issue with that when I use a cumulative calculation or in the total column my opening cash becomes the sum of all of the opening cash balances rather than the actual opening. (page 2 in the pbix file)

I tried to address this by just including the actual first opening cash balance in the forecast period, however I am struggling to understand what Dax I need so that in the first period it takes the actual opening but from then on the table should take the prior week closing figure. (page 1
Test BI_Closing balances.pbix (1.3 MB)
Updated cash flows - Alton version.xlsx (120.6 KB)
in the pbix)

I can use either one as long as I get Dax to give me the right answer. Any help would be greatly appreciated

2

Just wondering if any one can help with this one please

3

Bumping this post

4

Hi @Ronan

We noticed that your inquiry was left unsolved for quite some time now.

Looks like your inquiry was out of the experts and users’ bounds.

We strive to answer ALL inquiries in the forum. However, if you are sure that you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, you can check out our tutorials to learn this yourself as your membership also comes with relevant resources that may help you with your Power BI education.

While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done.

Due to the length by which this post has been active, we are tagging it as Solved.

For further questions related to this post, please make a new thread. Please feel free to reopen this thread if anyone would like to answer the pending inquiry above.

Thank you!