Notifications
Clear all
Power Query
3
Posts
3
Users
0
Reactions
167
Views
Topic starter
I would like to know how to get the updated interest calculation using Power Query for the given example below when choosing the date in E5, and it should be reflected monthly for recording. I used the formula in cell E17 =FV($E$3,DATEDIF($C7,E$5,"D")/365,,-$D7)-$D7
Please see the attachment
Thank you
Samuel
Posted : 06/05/2024 6:46 am
There is no attachment. Please try again and don't forget to press "Start upload" before you submit your reply.
Posted : 06/05/2024 7:25 am
Look at this link for a tutorial on PQ and Future Value Calculation.
https://www.thebiccountant.com/2023/01/02/future-value-function-fv-for-power-query/
Posted : 06/05/2024 11:21 am
