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

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

 

 

 

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

    Thank you lbendlin, worked perfectly.

    I also created a similar measure per day.

     

    Sales Avg Daily =
    var a = summarize('SALES', SALES[DATE])
    var b = ADDCOLUMNS(a,"sm",CALCULATE(sum(SALES[VALUE])))
    return AVERAGEX(b, [sm])