Forum Discussion
Solved
Beginner, need help finding a solution to filter based on another date column.
Hi all, bit of a newbie here doing his best after our main data guy just left and am here to pick up the peices. I have a list in power BI Desktop and have been requested to filter a column that...
ejethan123 Did you create it as a column or a measure? It needs to be a measure and you need to use it in a visual where the measure has the context for each associated date. If you want a column you would do this:
Selector Column = VAR __Date = [Submitted Date] VAR __Status = [Status] VAR __Result = IF( __Status = "Closed" && __Date < TODAY() - 30, 0, 1 ) RETURN __Result
danextian
Super User
Super UserHi ejethan123
This part of Greg's logic must be met for 0 to be returned
__Status = "Closed" && __Date < TODAY() - 30You're right. If there are rows with a closed status and dates earlier than 30 days, they will return 1. To return 0 for those with a closed status or dates older than 30 days, change && to ||
__Status = "Closed" || __Date < TODAY() - 30
Sorry for the confusion. What I am trouble shooting now is that everything returns a 1, even those with status "Closed" and dates older than 30 days, which is what I am trying to filter out.