Forum Discussion

sbone's avatar
sbone
Frequent Visitor
8 years ago

Mortgage Amortization Table Using DAX

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

Need Help

2 Replies

  • sbone's avatar
    sbone
    Frequent Visitor
    8 years ago

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

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    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