Forum Discussion

sanjanarama's avatar
sanjanarama
Icon for Resolver I rankResolver I
4 years ago
Solved

date 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 transform...
Need Help
  • sanjanarama's avatar
    sanjanarama
    4 years ago
    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
sanjanarama's avatar
sanjanarama
Icon for Resolver I rankResolver I
4 years ago
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