cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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 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
3 REPLIES 3
Memorable Member

Hi, @leroy773,
could you please share a picture with the result I am not sure about the final product?

Helper II

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,

Community Support

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors