Forum Discussion
Sudharsanan
Helper III
Helper IIIWeighted Avg calculation
Hi friends, I need help in calculating weighted avg for the below data using DAX. can someone help me? Logic: (Sum of CY sales)/((sum of PY sales)/(sum of PY qty))*sum of Cyqty)))-1 C...
Sudharsanan , Assuming all are columns
Divide(Sum(Table[CY sales]), Sumx(Table, Divide([PY sales],[PY qty]) * Table[Cyqty]) ) -1
amitchandak
Super User
Super UserSudharsanan , Assuming all are columns
Divide(Sum(Table[CY sales]), Sumx(Table, Divide([PY sales],[PY qty]) * Table[Cyqty]) ) -1
Sudharsanan