Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am looking assistance to calculate cumulative total based on quarters I select. I currently have a table where the cumulative number of days is calculated, but when I graph it shows the cumulative days when the serial number is installed. My relationship has date installed related to my date key. When I graph with quarters and years, it shows the total time installed in Q1 for serial numbers installed in Q1. I would like this time spread out over the quarters instead of summing the total and placing it solely in Q1. This duration should be spread out over all quarters. Any guidance would be appreciated
Serial Number | Date Installed | Time Installed | |
1 | 1/15/2019 | 1150.00 | |
2 | 1/9/2019 | 1156.00 | |
3 | 1/24/2019 | 1141.00 | |
4 | 1/25/2019 | 1140.00 | |
5 | 1/16/2019 | 1149.00 | |
6 | 3/6/2019 | 1100.00 | |
7 | 4/29/2019 | 1046.00 | |
8 | 4/29/2019 | 1046.00 | |
9 | 4/25/2019 | 1050.00 | |
10 | 4/24/2019 | 1051.00 | |
11 | 5/8/2019 | 1037.00 | |
12 | 4/24/2019 | 1051.00 | |
13 | 5/8/2019 | 1037.00 | |
14 | 5/15/2019 | 1030.00 | |
15 | 5/15/2019 | 1030.00 | |
16 | 5/13/2019 | 1032.00 | |
17 | 5/14/2019 | 1031.00 | |
18 | 5/16/2019 | 1029.00 | |
19 | 5/20/2019 | 1025.00 |
Hi, @leroy773,
could you please share a picture with the result I am not sure about the final product?
In the chart below as an example, Q1 shows the total time a that 6 instruments were installed. So Q1 shows 6836 days, but those 6836 days should be spread across all the qtrs from Q1 2019 to Q1 2022. So ideally those days would be approximately 546 days in each quarter and not lumped into the quarter the instruments were installed. Thanks,
Hi @leroy773 ,
Sorry still not very clear about your problem, which columns are in the chart and what's your formula? could you please provide more detailed explaination.
Best Regards,
Community Support Team _ kalyj
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |