Forum Discussion
daxdummy
Helper I
Helper ICost 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 populate...
daxdummyHelper I
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
Super Userdaxdummy , 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