Report Portal

Another Post about Calculating New and Returning Customers - Part 2

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:


Tags: design, dax, tabular


2007-2015 VidasSoft Systems Inc.