Getting Token eOF Error for formula, but not sure why. Still learning DAX.

[bcbuckley13]

I'm trying to create a column that tells me if someone completed a course before the Due Date, and if not, then Overdue. The initial challenge I had was that if someone didn't complete it at all yet, then I was getting  a Null.

IF [Course Complete Date] < [Due Date] then "Yes"
else
if [Course Complete Date] = null and [Due Date] = < TODAY()
then "Overdue"
else if [Course Complete Date] > [Due Date] then "No"
else "Pending"

[az38]

Hi @bcbuckley13 

use lowercase "if"

[bcbuckley13]

Thank you AZ38! That fixed that issue, but now I got this. 😞

[mahoneypat · Accepted solution]

TODAY() is a DAX function.  The equivalent in M is Date.From(DateTime.LocalNow())

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat