|
Another Post about Calculating New and Returning Customers - Part 2 |
|
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:
Read more... |