Forum Discussion
Advocate IISumif and averageif
Hi yasmin
You may try to use CALCULATE Function or AVERAGEX Function. Here is the document for you. If it is not your case, please share some data sample and expected output. You can upload it to OneDrive or Dropbox and post the link here.
https://powerpivotpro.com/2009/12/powerpivot-dax-calculate-is-a-supercharged-sumif/
https://community.powerbi.com/t5/Desktop/Average-of-last-6-months/td-p/128738
Regards,
Cherie
Microsoft EmployeeHi yasmin
You may try to use CALCULATE Function or AVERAGEX Function. Here is the document for you. If it is not your case, please share some data sample and expected output. You can upload it to OneDrive or Dropbox and post the link here.
https://powerpivotpro.com/2009/12/powerpivot-dax-calculate-is-a-supercharged-sumif/
https://community.powerbi.com/t5/Desktop/Average-of-last-6-months/td-p/128738
Regards,
Cherie