Skip to main content
cancel
Showing results for 
Search instead 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.

Reply
mickalowe
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
mickalowe
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

CodeEmployeeNDateTimeSpentProject
149054413/09/2018 00:00153697
149060413/09/2018 00:00153815
149063413/09/2018 00:00153739
149064413/09/2018 00:00153891
149065413/09/2018 00:00153820
149221412/09/2018 00:00153836
149223412/09/2018 00:00153829
149224412/09/2018 00:00153939
149227412/09/2018 00:00153716
149230412/09/2018 00:00153751
149231412/09/2018 00:00153716
149235412/09/2018 00:00153837
149236412/09/2018 00:00153565
149240411/09/2018 00:00153829
149243411/09/2018 00:00153859
149247411/09/2018 00:00153175
149250411/09/2018 00:00153716
149266410/09/2018 00:00153751
149271410/09/2018 00:00153932
149272410/09/2018 00:00153858
149280407/09/2018 00:00153829
149284407/09/2018 00:00153939

 

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

CodePosCodeProjectActivityExpenseCostEstBudTime
164  00
234  00
374  00
414  00
554  00
655  20000
186331  45006000
197331  45006000
2093565  450600
2163565  1050600
2233565  21001200
2313565  450600
2453565  1050600
2593565  450600
2663565  22002400
2773565  22002400
4693829  2000060000
4763829  2000060000
4833829  7500060000
49103829  4500060000
5073829  6000060000
5153829  9500060000
7093829  1000030000

 

Hope this is clear and thanks for looking.

speedramps
Super User
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.
Please provide examples

speedramps_0-1698342996404.png

 

Anand24
Super User
Super User

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

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

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors