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 as the one below:

      

 

8 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

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

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

  • talespin's avatar
    talespin
    Solution Sage
    2 years ago

    hi Thimios 

     

    Is it possible to share pbix file sample data and with all sensitive data removed.