Need to filter data like yesterday 5:00PM to Today 6:00PM

[Anonymous]

Hi All,

Need to filter data in one visual like yesterday 5:00PM to Today 6:00PM based on Stardate and starttime columns.

please help me with logic

Thanks in advance !!!!

Ravi

[amitchandak]

@Anonymous , Try like

Measure =
var _max = today()
var _t1 =_max + time(18,0,0)
var _t0 =(_max -1 )+ time(17,0,0)
return
calculate(Sum(Table[Value]),filter(Allselected(Table), Table[Datetime]>= _t0 && Table[Datetime]<= _t1))

[az38]

Hi @Anonymous 

try to create a column

isFiltered = 
IF(
(Table[Startdate] = TODAY()-1 && Table[Starttime] >= TIME(17,0,0) ) ||
(Table[Startdate] = TODAY() && Table[Starttime] <= TIME(18,0,0) ),
TRUE(),
FALSE()
)

then add this Column to visual filters and filter by True