Skip to main content
cancel
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

## 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
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!

Helper I

Anyone any input?

Helper I

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

Super User

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

Helper I

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

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Join our Community Sticker Challenge

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Power BI Monthly Update - July 2024

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

#### Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors