Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ZoltanFut
New Member

How to sum values from previous lines?

 

Hi guys,

 

I’ve a following problem:

 

There’s a table with the following columns:

Date

Value

2018.06.25

12

2018.06.26

12

2018.06.27

12

2018.06.28

4

2018.06.28

8

2018.06.29

1

2018.06.29

8

 

How can I add a column, that sums the values by the actual date in the row, like this?

 

Date

Value

SumValue

2018.06.25

12

12

2018.06.26

12

24

2018.06.27

12

36

2018.06.28

4

40

2018.06.28

8

48

2018.06.29

1

49

2018.06.29

8

57

 

Thanks for your suggestions in advance!

 

Zoltán

1 ACCEPTED SOLUTION
AlB
Super User
Super User

Hi @ZoltanFut

 

Try this for your new column. Note that this will yield the same result for all rows with the same date, since I see there are duplicates.

 

 

CumulativeSumValue =
CALCULATE (
    SUM ( Table1[Value] ),
    FILTER ( Table1, Table1[Date] <= EARLIER ( Table1[Date] ) )
)

 

View solution in original post

2 REPLIES 2
AlB
Super User
Super User

Hi @ZoltanFut

 

Try this for your new column. Note that this will yield the same result for all rows with the same date, since I see there are duplicates.

 

 

CumulativeSumValue =
CALCULATE (
    SUM ( Table1[Value] ),
    FILTER ( Table1, Table1[Date] <= EARLIER ( Table1[Date] ) )
)

 

Hi AlB,

 

thanks for the solution, and the idea, I can work toward on this  🙂

 

thanks

Zoltán

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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