topic Average month calculation in DAX Commands and Tips

Average month calculation

Anonymous — Thu, 10 Mar 2022 21:11:19 GMT

I want to calculate the average units per month. The formula I have is

Measure = AVERAGEX(VALUES(Dates[Month], 'Shipped Sales Detail'[Units]))

I get the error message "too many arguments were passed to the VALUES function. The maximum argument count for the function is 1. Can someone assist? Thank you!

Re: Average month calculation

VahidDM — Thu, 10 Mar 2022 22:30:30 GMT

Hi Anonymous

It because of ), try this:

Measure = AVERAGEX(VALUES(Dates[Month]), 'Shipped Sales Detail'[Units]))

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

Re: Average month calculation

Anonymous — Wed, 16 Mar 2022 09:09:51 GMT

Hi Anonymous ,

Please update the formula of Measure as below, the part with red font is updated one...

Measusre = AVERAGEX ( VALUES ( Dates[Month] ), 'Shipped Sales Detail'[Units] )

If the above one can't help you get your expected result, please provide some sample data(exclude sensitive data) and your expected result with backend logic and special examples. Thank you.

Best Regards