How to split the count of Leave days per calendar month if i have a From Date and To Date?

[omkarsawant30]

I have a employee leave data table. It has one row for each leave applied by the employees.

So we have columns - Employee Name, From Date, To Date, No. of Days of leave Taken.

How to calculate - Number of days of leave taken per calendar month?

Example: If Leave From Date - 29th Nov and Leave To Date - 4th Dec. Then i need to know how many days of this leave belongs to November and December separately.

My expected output is to show a bar chart with Months on X axis and Leave days on Y Axis.

[Ahmedx]

Refer to this solution
https://community.fabric.microsoft.com/t5/Desktop/DAX-Formular-count-days-over-month-between-two-day...