Forum Discussion

olimilo's avatar
olimilo
Post Prodigy
2 years ago

DATEDIFF calculated column returning incorrect value

I have a DATEDIFF calculated column that's returning incorrect values for all rows whose Review Due is past the current date:

 

 

 

 

 

 

 

Days Due = 
    SWITCH(
        TRUE(),
        'Data'[Review Date] = BLANK(), BLANK(),
        'Data'[Review Due] <= TODAY(), 0,
        DATEDIFF('Data'[Review Date], 'Data'[Review Due], DAY)
    )

 

 

E: My bad, it was computing properly 😂

Need Help

2 Replies

    • olimilo's avatar
      olimilo
      Post Prodigy
      2 years ago

      I just realized I was supposed to use the current date instead of the Review Date. My bad 😂