SWITCH FUNCTION not working for certain visuals for "Total Hours (Previous 30 Days)"

[magnify-bi-com]

Hey,

I have a SWITCH fucntion that is working for everything but "Total Hours (Previous 30 Days)", I'm presuming this is due to the way I've written the DAX for this measure as opposed to the others, the problem is that when I select the "Total Hours (Previous 30 Days)" option, some of my visuals don't display (The ones that are linked to other tables), If I just load the measure on it's own, then it works, so it's something to do with the way I've written the DAX that is preventing me using other tables fo visualisation.

Measure Selection (Hours) =

SWITCH( TRUE(),

VALUES('Date Period'[Date Period]) = "This Month", TimeSheet[Total Hours (MTD)],

VALUES('Date Period'[Date Period]) = "Previous Month", TimeSheet[Total Hours (Previous Month)],

VALUES('Date Period'[Date Period]) = "Previous 30 Days", [Total Hours (Previous 30 Days)],

VALUES('Date Period'[Date Period]) = "Year To Date", TimeSheet[Total Hours (YTD)],

VALUES('Date Period'[Date Period]) = "Custom", TimeSheet[Total Hours],

BLANK())

Total Hours = SUM(TimeSheet[Hours])

Total Hours (Previous Month) = CALCULATE([Total Hours]

,DATEADD(DATESMTD(Dates[Date]) ,-1 ,MONTH ) )

Total Hours (Previous 30 Days) = CALCULATE([Total Hours],

FILTER(ALL(Dates),

Dates[Date] > MIN(Dates[Date]) - 30 &&

Dates[Date] < MIN(Dates[Date])))

All of the rest work, but when I try and use "Total Hours (Previous 30 Days)" I get a blank visual

Any help would be welcomed.

Thanks,

J

[amitchandak · Accepted solution]

@magnify-bi-com , Try like this

Rolling 30 = CALCULATE([Total Hours],DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-30,DAY))

[magnify-bi-com]

Thanks Amit, foolishly, I think I just needed to change my MINs to MAXs, that seems to have done the trick.

But your soltuion worked also.

Thanks,

Jon