Say I have the following table(I will call it 'Schools'):
I want to see if I could create a 'running total' column(or measure if that's easier) based on the 'School' and 'Weeks' column, so it would look something like this:
How would I go about doing that?
Go to Solution.
Hey @LalitDatta ,
try the following measure, that should do it:
Running Total Pickups =
VAR vLastWeek = MAX( Schools[Week] )
SUM( Schools[Pickups] ),
Schools[Week] <= vLastWeek
View solution in original post
That worked! Thank you!
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.