Forum Discussion
Average & Weighted Average - help needed
Hi Community I'm seeking help with calculating an average and weighted average in my Power BI model. The excel file below shows what I'm trying to achieve. Thanks in advance for any guidance yo...
Hey HotChilli
I can't thank you enough. Your suggestions were spot on, nailing my issues right there. can I be super cheeky and ask for your help again with the weighted average? This formula:
Weighted Av = [% Increase] * [CY Total]
actually gives the answer to my NI/Share Profit calculation. Is the Weighted Average in my Excel file doable?
Thanks!
I'll have a go. How is it calculated?