Pivot rows depending on month interval using PowerQuery

[amirabedhiafi]

I have the following data set :

I want to pivot my data like below using PowerQuery:

So taking the row below as an example:

 

The end result for this row would be as follows :

The cost will be divided by the duration in days between the start and the end day.
Same for the consumption and emission columns.

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.