Cost Between Start and Finish Dates

[daxdummy]

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]

@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?

[daxdummy]

Anyone any input?

[daxdummy]

@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

[amitchandak]

@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...

[daxdummy]

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