Forum Discussion

gra_197's avatar
gra_197
Icon for Helper II rankHelper II
9 months ago
Solved

Adding an intererst rate

Hi all,   Help needed   I have 2 tables, one with invoices outstanding and the other one has 2 columns month and interst rate.   Whats the best way of showing in a table the invoice number, int...
Need Help
  • v-karpurapud's avatar
    v-karpurapud
    8 months ago

    Hi gra_197 

    Sure, these are the measures I included in the report. Please review them and share your feedback.

     

    Interest_Rate % =

MAX ( InterestRates[Interest Rate %] )

     

     

    Interest Amount =

VAR Rate =

    [Interest_Rate %] / 100

VAR Amount =

    MAX ( Invoices[Price] )

VAR Days =

    MAX ( Invoices[Days Overdue] )

RETURN

Amount * Rate * Days / 365


    If you have any more questions, please let us know and we’ll be happy to help.

     

    Regards,

    Microsoft Fabric Community Support Team.
     

     

v-karpurapud's avatar
v-karpurapud
Icon for Community Support rankCommunity Support
8 months ago

Hi gra_197 

I wanted to check if you’ve had a chance to review the information provided. If you have any further questions, please let us know. Has your issue been resolved? If not, please share more details so we can assist you further.

Thank You.