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...
amitchandak's avatar
amitchandak
Super User
5 years ago

venkb , if date table is joined with the table then try like for previous day

Received_Today_1 = COUNTROWS(FILTER (
ALLSELECTED(Logs),
&& Logs[State] = "State"
&& Logs[Status] = "Success"
), previousday('Date Table'[Date]))