Forum Discussion
How to make Contribution to Growth formula
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
Community SupportHi Anonymous,
It's expected that we can't add column to Column Series property if we already add more than one fields into Column Values section.
In your scenario, please share some sample data and show us the desired results, so we can test to see if your requirement can be achieved.
Best Regards,
QiuyunYu
Thanks for coming back v-qiuyu-msft.
You can find some data here:
https://www.dropbox.com/sh/vtld3ulkzqmi1ym/AAAxsCvX1DDnCa20e4WVsZ-0a?dl=0
I have been thinking - if I can add a column in the table that looks up last years sales on each SKU, Year, Period it should be easy. There is only one row per SKU/Period....
Thanks for looking into this!
Kent
- v-qiuyu-msft
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,
QiuyunYuThank you very much v-qiuyu-msft - It worked perfectly!