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

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

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

Top Solution Authors
Top Kudoed Authors