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...
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
daxdummyHelper I
Helper IThanks
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