Forum Discussion
Solved
Error when no Completion date
Hello, I've created two columns. One is a Custom column that just adds 30 days to the Reg Date (Due Date). The "Completed in 30?" column is a Conditional column to see if the user completed the cour...
Hi bcbuckley13 ,
You have to start the if with nulls.
The if should be something like if [Course Complete Data] = null then ........
write the other conditions with if else / else.
Power Query has a "try...otherwise" construct that you will want to use. maybe show your (sanitized) code.
Here's what I had, but still not working.
