topic How to Link Relative Date Slicer with Previous Period Measure in DAX Commands and Tips

How to Link Relative Date Slicer with Previous Period Measure

Anonymous — Tue, 22 Nov 2022 03:30:44 GMT

Hiya,

I am making some KPI cards, and am wishing to link the target values to the relative date slicer. (weeks, months, etc)

For example, when I choose "Last 2 months", I would like to get a "Previous Month" target.

When I choose "Last 2 weeks", I would like to get a "Previous Week" target.

I could not figure out how to 'extract' that input as some sort of unit to put in a measure.

Help would be much appreciated!

Re: How to Link Relative Date Slicer with Previous Period Measure

amitchandak — Tue, 22 Nov 2022 04:15:22 GMT

Anonymous , Try measure like

Last month =
var _max1 = if(isfiltered('Date'),Min( 'Date'[Date]) , today())
var _max = eomonth(_max1,-1)
var _min = eomonth(_max1,-2)+1
return
CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))

Last week =
var _max1 = if(isfiltered('Date'),Min( 'Date'[Date]) , today()) -7
var _max = _max1 - weekday(_max,2)+7
var _min = _max1 - weekday(_max,2)+1
return
CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))