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
sajal161292
Helper V
Helper V

To perform cumulative addition of a column in power bi

Hi,

 

I have prepared the sql query of a report in sql server.

There exists a one to many relationship.

A name can have multiple item_segments against it,an item_segment can have multiple due_dates and a due date should have 6 different order types against it.The requirement is to do cumulative addition of the quantity in all the weeks for a particular name and item_segment.

 

Inkedpowerbi1_LI.jpg

So I would like to have a column cumulativeweekly that could do the cumulative addition of the current week's total with the succeeding weeks.

For Week 50 = Total of week 49 + Total of week 50 = -7302 + (-2834) etc.

Please help me in achieving this.

19 REPLIES 19

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.