Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

How to make Contribution to Growth formula

Hi,     I want to calculate a measure where I sum up the growth of all products that have growth vs. last year and in another measure, I want to aggregate the decline of all the products that have...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi Anonymous,

     

    You can create a calculated column like below to get values in last year same weeknr for the same product:

     

    LastYearSameSKU-WEEKNR = LOOKUPVALUE(data[Value Sales'000],data[PRODUCT],'data'[PRODUCT],data[WEEKNR],'data'[WEEKNR],data[YEAR],'data'[YEAR]-1)

     

    Best Regards,
    QiuyunYu

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi Anonymous,

 

You can create a calculated column like below to get values in last year same weeknr for the same product:

 

LastYearSameSKU-WEEKNR = LOOKUPVALUE(data[Value Sales'000],data[PRODUCT],'data'[PRODUCT],data[WEEKNR],'data'[WEEKNR],data[YEAR],'data'[YEAR]-1)

 

Best Regards,
QiuyunYu

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Thank you very much v-qiuyu-msft - It worked perfectly!