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.
Hi gra_197
Thank you for contacting the Microsoft Fabric community forum.
The issue was related to the data model rather than the visual itself. I have implemented a DAX-based solution using sample data to demonstrate the correct approach, ensuring the interest rate is applied at invoice level based on the invoice month. I’ve attached the PBIX file along with a snapshot of the final output for reference. Please take a moment to review them and let me know your observations .
If you have more questions, please let us know and we’ll be glad to assist.
Best regards,
Microsoft Fabric Community Support Team.
v-karpurapud I have been unable to access the pbix on my phone. Are you ok to share the measure please?
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.