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.
     

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
9 months ago

Hi,

Share data in a format that can be pasted in an MS Excel file.  In another tab, show the expected result very clearly.