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.
     

     

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

You cannot do that in a table. Needs a matrix visual, and it will become awkward quickly if you have more than a handful of invoices and more than a dozen months.  Instead, consider aggregating your data (for example by ditching the invoice number details)

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

I have the date table set up and a relationship created between the two tables however the Interest rates are still not populating.

 

In order to pull in interest rates,Ive set up the table like so

 

01/10/2025.  2%

01/11/2025.  3%

01/12/2025.  4%

01/01/2026.   5%

01/01/2026.   6%

 

And I wonder is the reason it's not pulling the data in,because I have the date as the first of the month and if there are no invoices for this date, it won't pull any data?