Another Post about Calculating New and Returning Customers - Part 2
User Rating: / 0
Written by Gerhard Brueckl   
Tuesday, 05 March 2013 22:32

In my previous post I showed a new approach on how to calculate new (and returning) customers in PowerPivot/tabular using DAX. We ended up with a solution where we added the customers first order date as a calculated column to our customer-table. This column was then linked to our date-table with an inactive relationship. The final calculation used USERELATIONSHIP() to make use of this relationship as follows:




Pyramid Analytics