Forum Discussion
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...
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.
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)
