Make quarterly payments on loan fit into a 12 month calendar

[jaco1951]

Dear all 

I am not sure how to address this problem. I have a bunch of loans where the majority of them have semi annually or quarterly installments. 

I need to create a monthly view on all loans, which leads me to the issue on how to solve this. Should do it in the Query where each loan have a issuing date and maturity date. Or would it be better to do it in DAX and somehow create a virtual calendar to fill the gaps?

Br Espen

[Anonymous · Accepted solution]

Hi @jaco1951,

I'd like to suggest you to expand date range to detail date, then you can use detail date to create an calendar table and build relationship.

Convert date ranges into list of dates?

After these operation, you can use calendar direct operation each date between date range.

Regards,

Xiaoxin Sheng

[jaco1951]

Excellent function, I was not aware that one could do this. 

Thanks.