cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
slav84
Frequent Visitor

How to calculate weekly running total

Hi, 
I have table called WeeklyData with columns FiscalWeek and Count. 
I need to add another column (Not Measure)  that will have running totals. So for example in row of RunningTotal we would have 132, row two would be 132+654 and so on.
How would i do that ?

FiscalWeekCount
1132
2654
3987
4498
5658
6738
7918
8658
9468
10681
1195
12128
13642
14379
15728
16291
17675
1 ACCEPTED SOLUTION
mahoneypat
Super User
Super User

Here is a column expression that works.  Replace T1 with your actual table name.

 

RT =
VAR thisFW = T1[FiscalWeek]
RETURN
    SUMX ( FILTER ( T1, T1[FiscalWeek] <= thisFW ), T1[Count] )

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

2 REPLIES 2
mahoneypat
Super User
Super User

Here is a column expression that works.  Replace T1 with your actual table name.

 

RT =
VAR thisFW = T1[FiscalWeek]
RETURN
    SUMX ( FILTER ( T1, T1[FiscalWeek] <= thisFW ), T1[Count] )

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

Thank you. This worked like charm 😉

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!