Calculate weighted avg with filters

[Anonymous]

I have attached the datasheet from excel of how the calculation for my avg is done for each month.

I am intrested in getting this via dax for month and year wise. I sthere a possibility to get Freight Costs A$t Sales as "Freight Costs A$m"*1000/"Total PE / Spec Sales (t)"?

[Anonymous]

Hi @Anonymous ,

Please provide some sample data so that we could create a demo and test the formula.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 

Best Regards,

Jay