Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
@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))
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
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |