Calculating First and Second Year of Sales by Customer in #dax #powerpivot #ssas #tabular

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

I recently wrote an article that describes how to calculate a measure (such a sales, but it could be anything else) considering for each customer its first 12 months, then months 13-24 and so on. In practice, for every customer you have a different range of dates to consider, that starts on the date of its first order.


Tags: dax, design


2007-2015 VidasSoft Systems Inc.