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.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

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.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.