9 Replies Latest reply on Nov 8, 2016 7:31 AM by alex.apolloni.0

    how do you take orders and group by customer for calculations?



      My data table looks like so:

      [Date Of Order]  [Customer ID]  [Order ID]  [Product ID]  [Amount] 



      Row N



      How do I make a calculated field so that i can say, "give me the average Order amount by customer" over time.

      In SQL or DAX you could just GroupBy (or Summarize) by Date - Customer ID   - SUM(Amount)

      And then average.....onto a date.


      Many Thanks,



      Message was edited by: alex apolloni added  example workbook