Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Average month calculation

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!

  • Anonymous's avatar
    Anonymous
    4 years ago

    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

2 Replies

  • VahidDM's avatar
    VahidDM
    Super User
    4 years ago

    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/

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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