DAX - Unpivoting values based on the period

[Bone1897]

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.

[sandy666]

with Power Query (no DAX)

Circuit	June-2022	July-2022	August-2022	September-2022	October-2022	November-2022	December-2022	January-2023	February-2023
GG116083	121	121	121	121	121	121	121	121	121
GG142744							36.27	36.27
GG143168							127.86	127.86

[Bone1897]

Thank you very much. I resolved my problem with calculated columns, but I will use your solution in future projects, as it seems more efficient.

Have a nice day ahead.

[sandy666]

sure,

You are welcome