Forum Discussion
gra_197
Helper II
Helper IIAdding 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.
gra_197Helper II
Helper IIv-karpurapud I have been unable to access the pbix on my phone. Are you ok to share the measure please?
v-karpurapud
Community Support
Community SupportHi 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.