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 You want a Complex Selector. https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534
Probably along the lines of:
Selector Measure =
VAR __Date = MAX( 'Table'[Submitted Date] )
VAR __Status = MAX( 'Table'[Status] )
VAR __Result = IF( __Status = "Closed" && __Date < TODAY() - 30, 0, 1 )
RETURN
__ResultAdd that and filter for only 1's