Forum Discussion
Sanskruti
Helper II
Helper IIWhen using between slicer data doesn't show.
Hello, I have created a table which shows year month, order quantity and previous year order quantity. And i have added a date slicer. But when i change the date with the help of slicer i ...
amitchandak
Super User
Super UserSanskruti , Make sure you have a date table and slicer, visual and measure using date table columns
Try measure like
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))
SanskrutiHelper II
Helper IIThank you for replying,
But i'm using same expression.
"PY OQ = CALCULATE(SUM(Aw_TotalSales[OrderQuantity]),dateadd('AW_Calendar'[Date].[Date],-1,Year))"
But still when i use slicer and select 2017 i cant see 2016 data.
But still when i use slicer and select 2017 i cant see 2016 data.