Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Slicer

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!

Need Help

3 Replies

  • Arul's avatar
    Arul
    Super User
    4 years ago

    Anonymous ,

    Please provide sample data.

    Thanks,

    Arul

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago
      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!