cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
daxdummy
Helper I
Helper I

Cost Between Start and Finish Dates

Hi I have the data in the folowing format and I'm trying to calculate accrued cost between the dates

 

If the start date is blank then obviously costs will not accrue, if the start date is populated then the costs will accrue until finish date is populated

 

I am struggling with what I think should be a simple calculation, I can calculate in a column no problem, but when I try to calculate in conjunction with a date table I have not ben able to do this

ID     Start Date      Finish Date    Daily Cost 

A1    17/01/2020    28/12/2020   £5.00

B2    25/07/2020    28/08/2020   £4.25

C2    18/07/2020    25/07/2020   £2.50

 

5 REPLIES 5
VijayP
Super User I
Super User I

@daxdummy 

Between 17/1 and 28/12 the Daily Cost is £5 means total cost you want number of days between these two dates multiplied by 5? and you wanted a cumulative Data right?




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


Anyone any input?

@VijayP 

 

Yes that is correct, I want to be able to show on a line, the cost accrual over time and be able to filter to ID No's

@daxdummy , expected output is not clear. But I have blog on very similar topic. See if that can help-

How to divide/distribute values between start date or end date or count days across months/days: https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Thanks

 

I had a look at your blog, but it does not produce the expected results

 

Please see mocked up picture for desired output, I have changed the dates from above to keep the date range smaller in this example

 

daxdummy_0-1610955972269.png

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.