Fee between the range

[aam1932]

Hai,

I need help on this, as per below table, how to use formula in power pivot or power query.

What i need, fee per month automatic in the particular column if the start period and period end between the particular column. example item 1, the fee 50 per month, and start period from Feb 17 to Apr 17, therefore, the column feb17, mar17 and apr 17 have 50 value and the column 0.

Hope, you all understand what i mean.Thank you



[TABLE="width: 500"]
<tbody>[TR]
[TD]Item[/TD]
[TD]period start[/TD]
[TD]period end[/TD]
[TD]fee per month[/TD]
[TD]jan17[/TD]
[TD]feb 17[/TD]
[TD]mar 17[/TD]
[TD]apr 17[/TD]
[TD]may 17[/TD]
[TD]jun 17[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]feb 17[/TD]
[TD]apr 17[/TD]
[TD]50[/TD]
[TD][/TD]
[TD]50[/TD]
[TD]50[/TD]
[TD]50[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]mar 17[/TD]
[TD]may 17[/TD]
[TD]100[/TD]
[TD][/TD]
[TD][/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]jan 17[/TD]
[TD]jun 17[/TD]
[TD]25[/TD]
[TD]25[/TD]
[TD]25[/TD]
[TD]25[/TD]
[TD]25[/TD]
[TD]25[/TD]
[TD]25[/TD]
[/TR]
</tbody>[/TABLE]