Forum Discussion

Thimios's avatar
Thimios
Helper 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.

     

     

     

Thimios's avatar
Thimios
Helper III
2 years ago

Hard one talespin. This is a huge model and requires lot of work...

Will try to provide a similar one, hopefully soon.

  • lbendlin's avatar
    lbendlin
    Super 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
      Helper 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])