Forum Discussion

venkb's avatar
venkb
Helper I
5 years ago

Filter rows based on date column

hello, I have the following measure   Received_Today_1 = COUNTROWS(FILTER ( ALLSELECTED(Logs), Logs[Date] = SELECTEDVALUE('Date Table'[Date]) - 1 && Logs[State] = "State" && Logs[Status] = "Su...
venkb's avatar
venkb
Helper I
5 years ago

thanks amitchandak, i tried the previousday function but it is still giving me the current day data. And yes the tables are linked through date.

 

btw, my goal is to for the last 7 days from the current date. so may need outside of previousday function even if it worked (sorry - i should have mentioned that in my original note)