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

here you go - i have a date slicer and i select a single date from it. based on the selection i am wanting to calculate the following measure. how many rows had a status & state of success and state respectively for

  • the selected date
  • selected date - 1
  • selected date - 2 and so on ie for the last 7 days of selected date

hope this helps