Cost Between Start and Finish Dates

Question

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

vijayp · Answer

daxdummy&nbsp;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?

daxdummy · Answer

VijayP&nbsp;&nbsp;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 · Answer

Anyone any input?

amitchandak · Answer

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-or-end-date/ba-p/1503785

daxdummy · Answer

Thanks&nbsp;I had a look at your blog, but it does not produce the expected results&nbsp;Please see mocked up picture for desired output, I have changed the dates from above to keep the date range smaller in this example&nbsp;&nbsp;

Forum Discussion

Cost Between Start and Finish Dates

5 Replies

Related content

User Group Leader Get Started Guide

DAX with calculation between start and finish dates

Lakehouse Cold Start

Spread a value over a finish and start date

Calculate Latest Start and Earliest Finish Time