Finding the of a forward balance

[sophtee]

Hello everyone,

I would like to get the balance by adding want was in a previous column (It is hard to explain so I will provide an example):

The database is filtered and I would like to get the red values: which starts with 0 then (1898+937.5 = 2835.94) then the 2835.94+696.09 = 3532.03.

Is there a way to do this on Power BI?

[v-venuppu]

Hi @sophtee ,

I hope the information provided is helpful.I wanted to check whether you were able to resolve the issue with the provided solutions.Please let us know if you need any further assistance.

Thank you.

[v-venuppu]

Hi @sophtee ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.

[v-venuppu]

Hi @sophtee ,

I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

Thank you.

[v-venuppu · Accepted solution]

Hi @sophtee ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @FBergamaschi for the prompt response.

I have developed a PBIX file using sample data to replicate the scenario.Please go through the attached PBIX file for your reference.

If this doesn't help kindly share the sample data and expected output, so that it will be helpful for us to dig into the issue.

Thank you.

[FBergamaschi]

In Power BI is is easy to get, respectively

1898.44

2835.94

3532.03

But you ask for a zero at the beginning

Why to you want zero the first time but the sum of the first and second value the second time?

best

F

[sophtee]

Good day,

Because it is the start of a new GrowoutID ( new batch), but it don't have to be 0 since it will be pulling from the previous entry.

Is there a way to get the previous entry from the filters?

[FBergamaschi]

yes, with a visual calculation using the PREVIOUS function

but to help more, I need the pbix

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI