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.

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!