Forum Discussion
Adding an intererst rate
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.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
