how can i get sales "variance % group" as slicer

[nandukrishnavs]

Product	Date	Sales($MM)
Product A	1-1-2014	500
Product B	1-1-2014	350
Product A	1-1-2015	900
Product B	1-1-2015	550
Product C	1-1-2015	410

Triying to get sales variance % group into slicer. For example slicer value will be "0% to 30 %", "31% to 60%" and "61% to 100 %".

Is there any way to get previous year sales into calculated column?

For example 

Product	Date	Sales ($MM)	Previous Year Sales ($MM)
Product A	1-1-2014	500	0
Product B	1-1-2014	350	0
Product A	1-1-2015	400	500
Product B	1-1-2015	550	350
Product C	1-1-2015	410	0

[v-yulgu-msft · Accepted solution]

Hi @nandukrishnavs,

---

Triying to get sales variance % group into slicer. For example slicer value will be "0% to 30 %", "31% to 60%" and "61% to 100 %".

You should add a calculated column which displays values "0% to 30 %", "31% to 60%" and "61% to 100 %" in source table. Then, drag this calculated column into slicer.

---

 Is there any way to get previous year sales into calculated column?

For example 

Product	Date	Sales ($MM)	Previous Year Sales ($MM)
Product A	1-1-2014	500	0
Product B	1-1-2014	350	0
Product A	1-1-2015	400	500
Product B	1-1-2015	550	350
Product C	1-1-2015	410	0

---

Previous Year =
LOOKUPVALUE (
    'Sales Table'[Sales($MM)],
    'Sales Table'[Product], 'Sales Table'[Product],
    'Sales Table'[Date].[Year], 'Sales Table'[Date].[Year] - 1
)
    + 0

Best regards,

Yuliana Gu