Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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


Super User
Super User


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?



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:



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




Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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