Create Daily Periodic Interest Rate Index from Monthly Summary

[BSwan]

Hello,

I'm looking for assistance in utilizing PQ to create a tabular dataset that will list the daily periodic interest rate for bank loans, given monthly summaries (typical bank 360 day year used to divide annual rate). Please see the simple example attached.

Any suggestions would be great!

Thanks!

-Blake

 

[Comfy]

See the attached file.

The Calendar table was generated using code from Chris Webb: https://blog.crossjoin.co.uk/2013/11/19/generating-a-date-dimension-table-in-power-query/

You may not need the additional columns so can adjust accordingly.

 

[Comfy]

There needs to be a small adjustment to the Calendar table, update the following line:

NumberOfDates = Duration.Days(EndDate-StartDate),

to

NumberOfDates = Duration.Days(EndDate-StartDate) + 1,

 

[BSwan]

Hi Comfy,

This is precisely what I was looking for -- thanks very much for your prompt reply to this!

 

[Comfy]

You're very welcome.