Date slicer buttons last 7 days, last 30 days, last 12 months

[Anonymous]

Hi,

I have a table for customer ids and transaction info. I have another table "Calender" which helped me to find a measure average transactions per day per customer. Now I need to make 3 buttons without using relative date slicer, which will give me last 7 days, last 30 days, last 12 months so that the values in dashboard change accordingly. Kindly guide me, Thanks!

[johnt75 · Accepted solution]

One option would be to create a calculation group with items for each period you want to cover, e.g.

Last 7 days =
CALCULATE (
    SELECTEDMEASURE (),
    DATESBETWEEN ( 'Date'[Date], TODAY () - 7, TODAY () )
)

Last 30 days =
CALCULATE (
    SELECTEDMEASURE (),
    DATESBETWEEN ( 'Date'[Date], TODAY () - 30, TODAY () )
)

Last 12 months =
CALCULATE (
    SELECTEDMEASURE (),
    DATESBETWEEN ( 'Date'[Date], EOMONTH ( TODAY (), -13 ) + 1, TODAY () )
)