DAX - Unpivoting values based on the period

Hi all,

I have a file that contains the circuit, the charge and the dates those charge is related to.

The dates are in two columns (Start Date and End Date).

I would like to unpivot this table and proportionally distribute the charge as per the period it is related to.

The problem exists when the Start Date and the End Date are in different periods.

For an instance, Start Date 01/12/2023 and End Date 18/02/2023.

Please check the file and it will be clear to you.

All this should be done in Power BI.

Thank you very much. I appreciate it.