Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

filter on value

Hi, 

 

I hope you can help me on this one.

 

I have three measure

1. "Value" that accumulate the sum of sales this period

      4W VALUE = sum(Data[FCT_Value Sales'000])*1000

 

2. "Value YA" that accumulate the sum of sales year ago

     4W VALUE YA = CALCULATE(
          'a VALUE'[4W VALUE];
               FILTER(ALL('Calender');
              'Calender'[index]>MAX('Data'[Per_Index])-14
              &&'Calender'[index]<=MAX('Data'[Per_Index])-13
              )
          )

 

3. "Growth" that calculates the difference

     4W VALUE GROWTH YA = 'a VALUE'[4W VALUE]-'a VALUE'[4W VALUE YA]

 

Now I want a measure that calculates the value of the products that is new this year (Value = Growth).

 

(I'm not using Time intelligence as my sales in accumulated in periods of 4 weeks)

 

How can this be done?

 

Hope you can help!

 

Br Kent