Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I want to calculate the weighted average in terest rate for deposits considering the following variables:
- Deposit amount;
- Interest Rate; and
- activation date
The table below is showing the result i got using sumproduct function in excel.
Solved! Go to Solution.
@Figueiredo_Luis , It need to like
divide(Sumx(Table, [Value1] *[Value2]),sum(Table[Value1]) )
@Figueiredo_Luis , It need to like
divide(Sumx(Table, [Value1] *[Value2]),sum(Table[Value1]) )
Thanks for your support.
Regards,
FLuis
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |