cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
newbieuser
Helper I
Helper I

Running Total by Week and Shift

  1. I have a raw data table that has the following fields: Date, Time and Weight.
  2. I have managed to summarize it by adding some calculated columns so the summary table has the following fields: Date, Week Start Date, Day of Week, Shift and Weight.
  3. So far so good. Please bear with me while I try to articulate the question 🙂
  4. This is a link to the data https://drive.google.com/file/d/11FbpmZS71bx1DZqR84s6XOsdYDoemndO/view?usp=sharing
  5. I have two visuals on two different pages of a report - both these pages use various page filters in addition to the "AM" or "PM" shift filter such that one page is specifically for morning shift and the other for evening shift.
  6. Now I want to show a running "Week to date" total for the Weight on both the pages.
  7. The complexity is that on the morning shift page it should show the running total of all previous days in the week AND the weight of the current "AM" shift.
  8. And on the evening shift page it should show the running total of all previous days in the week including the current "PM" shift.
  9. Both pages have selectable "DATE" slicer.
  10. No filters on either page can be changed!! 😞

Please let me know how to calculate such a running weekly total. It works with a pivot table visual on a blank page, but as soon as I put it on one of these pages the result defaults to the daily total regardless of "Shift".

1 ACCEPTED SOLUTION
newbieuser
Helper I
Helper I

I solved this myself!! 😀

View solution in original post

1 REPLY 1
newbieuser
Helper I
Helper I

I solved this myself!! 😀

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

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

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors