topic Re: Date slicer buttons last 7 days, last 30 days, last 12 months in DAX Commands and Tips

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

Anonymous — Mon, 13 Mar 2023 13:38:17 GMT

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!

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

johnt75 — Mon, 13 Mar 2023 14:48:45 GMT

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 () ) )