Days between two dates : But only the value of one month

[SteveChoj]

Hi dear Community,

I would have to calculate the occupancy, i.e. person X has occupied bed Y from date X to date Y in days Z.
Ex :

You have Date/Heure Entrée Séjour and Date/Heure Sortie Séjour, first example : from 27/01/2022 to 25/03/2022 are 57 Days.

But now I only need 

January -> 4 Days

February -> 28 Days

March -> 25 days.

I need this in the form of a table - where all months are included and I can see the occupancy per month.
How would you proceed? I am completely lost at the moment...

Thanks 🙂

[amitchandak]

@SteveChoj , refer if these can help

Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM

Table way
https://amitchandak.mediumcom/dax-get-all-dates-between-the-start-and-end-date-8f3dac4ff90b
https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2