Forum Discussion
sanjanarama
Resolver I
Resolver Idate column measure to filter
I have a date column and want show the results in table which has date
1. greater or equal to today and
2. also has null values in it.
I dont want to add this in the transformation steps / filter in filter panel do not satisfy my requirements. any suggestions over measure to add to results table?
- AgeFilter = IF('Table'[Date]>= TODAY() || ISBLANK('Table'[Date]), 1 , 0)
I created new column and added this column in filter pannel to filter always to 1. this satisfied my requirement
2 Replies
- amitchandak
Super User
sanjanarama , Create a measure like
calculate(sum(Table[value]), filter( Table, Table[Date] >= today()) )
or
calculate(sum(Table[value]), filter( Table, Table[Date] >= today() && not(isblank(Table[Date])) ) )
sanjanaramaAgeFilter = IF('Table'[Date]>= TODAY() || ISBLANK('Table'[Date]), 1 , 0)
I created new column and added this column in filter pannel to filter always to 1. this satisfied my requirement
