HI,
I have a table of loans, each row is a loan, I would like to generate the amortization schedule of all the loans.
I was thinking to generate all the amortization schedules to one single table so I can upload it to a data model and then browse through pivot tables and create dashboards out of it.
I believe that the best tool would be vba to generate the big amortization table to a specific sheet and then have powerquery refer to this sheet?, the macro would redo everything each time is called but the sheet would be constant.
- Could it be done with dax?, I believe maybe with powerbi since in powerpivot you can´t generate tables from others
- Could it be done with powerquery?, It seems it would require a lot of m code
Appreciate any comment or suggestion, thanks
I have a table of loans, each row is a loan, I would like to generate the amortization schedule of all the loans.
I was thinking to generate all the amortization schedules to one single table so I can upload it to a data model and then browse through pivot tables and create dashboards out of it.
I believe that the best tool would be vba to generate the big amortization table to a specific sheet and then have powerquery refer to this sheet?, the macro would redo everything each time is called but the sheet would be constant.
- Could it be done with dax?, I believe maybe with powerbi since in powerpivot you can´t generate tables from others
- Could it be done with powerquery?, It seems it would require a lot of m code
Appreciate any comment or suggestion, thanks
