cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Carry Over values from previous month

Hi,

Just wondering to get some help with regards to my problem.

I am doing a power bi calculation in which will let the first month to have a value of "0" and then carry over the values of the previous months adding the value of the current month.

Ex.

March = 0 or blank
Apr = 0 (from March) + 5 (curr month) = 5
May = 5 (from Apr) + 10 (curr month) = 15
etc...

Microsoft Employee

@dantabangcura wrote:

Hi,

Just wondering to get some help with regards to my problem.

I am doing a power bi calculation in which will let the first month to have a value of "0" and then carry over the values of the previous months adding the value of the current month.

Ex.

March = 0 or blank
Apr = 0 (from March) + 5 (curr month) = 5
May = 5 (from Apr) + 10 (curr month) = 15
etc...

@dantabangcura

You can create a measure as below. See more details in the attached pbix file.

```runningTotal =
VAR FirstMonth =
CALCULATE ( MIN ( Table[date] ), ALLSELECTED ( Table ) )
VAR CurrentMonth =
MIN ( Table[date] )
VAR MonthNextToFirstMonth =
DATE ( YEAR ( FirstMonth ), MONTH ( FirstMonth ) + 1, 1 )
RETURN
(
IF (
CurrentMonth = FirstMonth,
0,
CALCULATE (
SUM ( Table[value] ),
FILTER (
ALL ( Table ),
Table[date] >= MonthNextToFirstMonth
&& Table[date] <= CurrentMonth
)
)
)
)```

Announcements

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors