How to allocate days into months using a start and end date as a measure

[sam.mckay]

Hi Anthony,

If you have a demo model to share that is always the best to get a solution fast. There can be a lot at play here included the data model you have, context of the calculation etc.

One thing though is have you watched this video here. My feeling is that the solution is quite similar to what you need. The scenario is different but the formula to solve it seems like it would suit your requirements of allocating results across different months.

See below

Calculate The Occupancy Days Per Month In Power BI Using DAX

This came from a recent forum post here

How to create new measure that calculates occupancy per month between two date columns?

One thing I would recommend here first is actually attempt to give it go in the model. The best way to learn is to just start writing DAX, create models etc. It will also speed up how we can assist you. First you need a date table (always). Not going to get very far without one here. [How To Create A Detailed Date Table In Power BI Fast] What you ultimately need to solve this is derivative of the ‘events in progress’ pattern that can be found below. It’s all about managing multip…

See how you go with these.

Thanks
Sam