Report Portal

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

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.

Read more...

Tags: design, dax, tabular

 

2007-2015 VidasSoft Systems Inc.