Forum Discussion
Solved
Over Due Review Calculation
Good morning! As I am getting acclimated to the calculations of DAX, I am trying to do a calculation of an overdue review. I have a series of review dates in a column. If the review is 30 da...
Let's simplify a bit:
Over Due = IF (TODAY() >= Sheet1[Next Review Date] + 30, "Over Dude", "Not Yet Due")
Hi Anonymous,
That formula seems very straight forward, however, it didn't do what I think it was intended. I have a conditional column that says if today is greater than the next review date then "Over Due" and it gives me a value of 543. The formula you gave gives me the same value. The value should be lower. Not sure what's up. Thanks so much for the continued help. :)
Your Next Review Date column -- is it of type Date!?
Yes indeedy.