Forum Discussion

kurumy's avatar
kurumy
Frequent Visitor
9 years ago

Client Activity evolution between two years

Hello everyone :) i've been asked to find a way to compare customers activity between two years. I don't need to have the exact values of their purchases but i have to show if between one time inte...
Tutorial Requests
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
9 years ago

kurumy,

 

Please take a closer look at measures new and stopped. The only difference is the order of the two expressions for EXCEPT Function.

kurumy's avatar
kurumy
Frequent Visitor
9 years ago

I saw that.

 

As long as  i understand  in the "New" measure you used the function EXCEPT because you compared the orginal table with a filtred table ( with a precise year).  If there is a difference between theses two tables inside the customers ID colonn, the functions count as 1. Am i Right ?

 

In your formula when you use "-1", is that for choose a filtrer with a the previous year ( year n-1) ?

 

The data i use is the aggregation of data from 2015,2016,2017. is it possible to use the function except by compare a filtred table from a precise year  (2015 ;2016 or 2017) with the original one ?

 

thanks

  • kurumy's avatar
    kurumy
    Frequent Visitor
    9 years ago

    Does someone have a solution ?