Forum Discussion
Cumulative total on a weekly basis with text based values
Hello
I'm trying to calculate the cumulative value on a weekly basis for deliveries in logistics.
So starting from two time stamps, I calculated the relative difference between the two.
Based on the value of the time difference I then gave a "text name" by using a conditional column with in total 4 values (Name: Delivery Precision Visual - subcategories: Missing, Pre Time, On Time, Late).
I also have a separate column tracking the arrival week (Name: Arrival week).
Those colums I have made in the power query.
Now to the point: To calculate the cumulative total I used following formula via Quick Measures:
Now as you can see, in the weeks where I don't have all 4 values in a specific week (most visable in week 29 & 52), the total value of the previous weeks isn't shown. The code is only taken into account the values present in that week + the weeks before of those values. Yet I want a continuation of the measures who are not present in that specific week.
How do I fix this?
Thanks a lot in advance!
1 Reply
- lbendlin
Super User
To report on things that aren't there you need to use disconnected tables and cross joins.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523