I am trying to calculate a cost variance analysis tab in one of my reports. I want to calculate the average of the cost of goods by month and then taking each month in turn and calculating the square of the difference between the cost for the month and the average cost for that product for FY’20.
Could anyone guide me on which measures should I create to get this result. Attached sample excel to show the results I need.
I have the Actual Cost and Total Cost = SUM(Actual Cost) measures created in my dashboard.
NupurCopy of Book3.xlsx (9.3 KB)