cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
leroy773
Helper II
Helper II

I am looking for assistance to show cumulative duration based on quarter selection.

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 NumberDate InstalledTime Installed 
11/15/20191150.00 
21/9/20191156.00 
31/24/20191141.00 
41/25/20191140.00 
51/16/20191149.00 
63/6/20191100.00 
74/29/20191046.00 
84/29/20191046.00 
94/25/20191050.00 
104/24/20191051.00 
115/8/20191037.00 
124/24/20191051.00 
135/8/20191037.00 
145/15/20191030.00 
155/15/20191030.00 
165/13/20191032.00 
175/14/20191031.00 
185/16/20191029.00 
195/20/20191025.00 
3 REPLIES 3
vojtechsima
Super User
Super User

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,

 

 

leroy773_0-1646949391367.png

 

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

 

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.