Forum Discussion

shippen70's avatar
shippen70
Helper I
5 years ago
Solved

Custom Column in Date Range

I'm trying to create a custom column in my date table to determine if the date is Less than today and equal to or greater than -182 days.  When I use the below syntex all the dates in the table retur...
Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    You may be over complicating things a bit.

     

    IsInPrev6Mo = 'Rolling Calendar'[Calendar Date]< TODAY() && 'Rolling Calendar'[Calendar Date]> TODAY()-182
lbendlin's avatar
lbendlin
Super User
5 years ago

You may be over complicating things a bit.

 

IsInPrev6Mo = 'Rolling Calendar'[Calendar Date]< TODAY() && 'Rolling Calendar'[Calendar Date]> TODAY()-182