Forum Discussion
Helper ICost Between Start and Finish Dates
Community ChampionBetween 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?
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
- amitchandak
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-or-end-date/ba-p/1503785
- 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
