Forum Discussion
Getting Token eOF Error for formula, but not sure why. Still learning DAX.
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"
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
3 Replies
Hi bcbuckley13
use lowercase "if"
Thank you AZ38! That fixed that issue, but now I got this. 😞
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
