filter on value

[Anonymous]

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

[Greg_Deckler]

Really need sample data/example data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490