Mortgage Amortization Table Using DAX

[sbone]

All,

I need to build a mortgage amortization in Power BI using user controlled parameters in a PBI report. For some reason I can't quite make it work using dynamic tables, even though intuitively it seems like it should be easy. Can anyone out there give me some guidance?

Thank you very much in advance!

Stephen

[v-yulgu-msft]

Hi @sbone,

In Power BI, dynamical table is not supported. However, we can create measures to return dynamical values based on user selection. Besides, for dynamic dataset, you could try query parameters. 

Best regards,

Yuliana Gu

[sbone]

WE WILL BE MOVING AWAY FROM POWER BI SINCE IT CANNOT HANDLE MORTGAGE AMORTIZATION TABLES WITHOUT RECALCULATING IN THE EXCEL SOURCE.