Forum Discussion

sokatenaj's avatar
sokatenaj
Advocate II
9 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Let's simplify a bit:

     

    Over Due = IF (TODAY() >= Sheet1[Next Review Date] + 30, "Over Dude", "Not Yet Due")

     

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Can you please clarify if you are trying to write a calculated column vs a measure?  

 

The way you have it written, I am going to guess calc column, and it looks like you are adding 30 to ... MONTH and YEAR !?

 

Over Due= SWITCH (
TRUE (),
Today() >= DATE (( DAY ( Sheet1[Next Review Date] ) + 30), MONTH ( Sheet1[Next Review Date] ) + 30), DAY ( Sheet1[Next Review Date] ) + 30), "Over Due", "Not Yet Due" ))

 

If you just remove the RED does it do what you want!?