cancel
Showing results for
Did you mean:

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.

Frequent Visitor

## Calculating Cumulative Totals by Date/Parameter

Hi All,

I'm having problems trying to build a cumulative graph based on 2 values from 2 tables. Line 1 needs to show time worked on a task drom <date a> to <date b> based on a specific activity, line 2 needs to be based on a budget of time starting at 0 from <date a> to the total value of the budget at <date b>.

Does this sound feasable?

Thanks

Mick

3 REPLIES 3
Frequent Visitor

Not sure what happened to my reply but I'll add it again....

First graph I want to accumulate TimeSpent by Project by NDate, the Y axis would start from the earliest NDate for Project and finish on the last NDate by Project:m the X axis would be TimeSpent

 Code Employee NDate TimeSpent Project 149054 4 13/09/2018 00:00 15 3697 149060 4 13/09/2018 00:00 15 3815 149063 4 13/09/2018 00:00 15 3739 149064 4 13/09/2018 00:00 15 3891 149065 4 13/09/2018 00:00 15 3820 149221 4 12/09/2018 00:00 15 3836 149223 4 12/09/2018 00:00 15 3829 149224 4 12/09/2018 00:00 15 3939 149227 4 12/09/2018 00:00 15 3716 149230 4 12/09/2018 00:00 15 3751 149231 4 12/09/2018 00:00 15 3716 149235 4 12/09/2018 00:00 15 3837 149236 4 12/09/2018 00:00 15 3565 149240 4 11/09/2018 00:00 15 3829 149243 4 11/09/2018 00:00 15 3859 149247 4 11/09/2018 00:00 15 3175 149250 4 11/09/2018 00:00 15 3716 149266 4 10/09/2018 00:00 15 3751 149271 4 10/09/2018 00:00 15 3932 149272 4 10/09/2018 00:00 15 3858 149280 4 07/09/2018 00:00 15 3829 149284 4 07/09/2018 00:00 15 3939

The second graph needs to be a straight line from 0 to accumulated  total based on the dates above so eefectively a straight line.

 Code PosCode Project Activity Expense CostEst BudTime 1 6 4 0 0 2 3 4 0 0 3 7 4 0 0 4 1 4 0 0 5 5 4 0 0 6 5 5 2000 0 18 6 331 4500 6000 19 7 331 4500 6000 20 9 3565 450 600 21 6 3565 1050 600 22 3 3565 2100 1200 23 1 3565 450 600 24 5 3565 1050 600 25 9 3565 450 600 26 6 3565 2200 2400 27 7 3565 2200 2400 46 9 3829 20000 60000 47 6 3829 20000 60000 48 3 3829 75000 60000 49 10 3829 45000 60000 50 7 3829 60000 60000 51 5 3829 95000 60000 70 9 3829 10000 30000

Hope this is clear and thanks for looking.

Super User

Provide example input data as table text (not a screen print) so we can import the data to build a solution for you.
Also provide the example desired output, with a clear description of the process flow.

Remember not to share private data ... we don't want you to get into trouble. 😧

Take time and care to use the same table and field names in the input, output and description so we can understand your problem and help you.

You will get a quick response if you put time, care and effort into writing clear problem descriptions.

Vaugue descriptions can waste your time and ourtime.

Look foward to helping you when the above information is forthcoming

Does the budget have a single value like this with no start date?
If so, then how do you want this compared with the actuals.

Super User

Hi @mickalowe ,
Can you provide some sample data and expected result?

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

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

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors