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?

    alex.apolloni.0

      Hello.

      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,

      Alex

       

      Message was edited by: alex apolloni added  example workbook