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.

     

     

     

talespin's avatar
talespin
Icon for Solution Sage rankSolution Sage
2 years ago

hi Thimios 

 

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

  • Thimios's avatar
    Thimios
    Icon for Helper III rankHelper 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
        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.