Slicer

[AT221098]

hello everyone! i am new 

i want to create a slicer  includes: last 7 days, last 30 days, last month, last year, current month, current year for filter all report. But when i  created and i choose one of the options above, my report don't show same period last year. help me, please!

[AT221098]

[Arul]

@AT221098 ,

Please provide sample data.

Thanks,

Arul

[AT221098]

Date Filter =

VAR _today = TODAY()

RETURN

UNION( ADDCOLUMNS(

CALENDAR(_today, _today),

"Filter", "TODAY",

"Order", 0

),

ADDCOLUMNS(

CALENDAR( _today - 7, _today),

"Filter", "LAST 7 DAYS",

"Order", 1

),ADDCOLUMNS(

CALENDAR( _today - 30, _today),

"Filter", "LAST 30 DAYS",

"Order", 2

),ADDCOLUMNS(

CALENDAR( _today - 365, _today),

"Filter", "LAST 360 DAYS",

"Order", 3

),ADDCOLUMNS(

CALENDAR( _today - 730, _today),

"Filter", "LAST 730 DAYS",

"Order", 4

),ADDCOLUMNS(

PREVIOUSMONTH(DATESMTD('Date'[Date])),

"Filter", "LAST MONTH",

"Order", 8

),ADDCOLUMNS(

DATESQTD('Date'[Date]),

"Filter", "CURRENT QUARTER",

"Order", 6

),ADDCOLUMNS(

PREVIOUSQUARTER(DATESQTD('Date'[Date])),

"Filter", "LAST QUARTER",

"Order", 9

),ADDCOLUMNS(

DATESYTD('Date'[Date]),

"Filter", "CURRENT YEAR",

"Order", 7

),ADDCOLUMNS(

PREVIOUSYEAR( DATESYTD('Date'[Date])),

"Filter", "LAST YEAR",

"Order", 10

),ADDCOLUMNS(

DATESMTD('Date'[Date]),

"Filter", "CURRENT MONTH",

"Order", 5

),ADDCOLUMNS(

CALENDAR(MIN('Date'[Date]),MAX('Date'[Date])),

"Filter", "ALL TIME",

"Order", 11

),ADDCOLUMNS(

CALENDAR(MIN('Date'[Date]),MAX('Date'[Date])),

"Filter", "CUSTOM",

"Order", 12

))

)

I want to select last month, the same period will show the value. Thank you so much!