Forum Discussion

Thimios's avatar
Thimios
Icon for Helper III rankHelper III
2 years ago
Solved

Hourly average sales

Hi all, I have a large sales table (sample below) with sales lines for the last 5 years.         I need to calculate average hourly sales per year so I can have multiple lines in a visual such...
  • lbendlin's avatar
    lbendlin
    2 years ago

    You didn't specify if you want this per order or per line item.  I assumed the former.

     

     

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Sounds good. What have you tried and where are you stuck?

  • Thimios's avatar
    Thimios
    Icon for Helper III rankHelper III
    2 years ago

    Thanks for asking lbendlin .

    Tried using Sales Avg Hourly = AVERAGEX( VALUES( 'Time Table'[Hour] ), [SALES] ) where 

    • 'Time Table' is a support table
    • SALES = SUM ('Sales'[VALUE])

    What I get in line chart, shows Total Sales (the sum of sales) instead of the average.

    Here is the above as table:

    Could it be that a miss something about hte context?