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
Greg_Deckler
Community Champion
Community Championejethan123 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
Greg_Deckler For some reason the measure was returning all 1s in the visual. I made a column though as you suggested above and filtered by it and just hit it from the visual and it worked as intended! Thanks for the help. Excited to continue learning.