Forum Discussion
Cannot convert value '' of type Text to type Number.
Anonymous
It's probably because you have empty strings there, you can check for the blanks or empty strings first and then execute otherwise do nothing:AddDate = IF ( NOT(ISBLANK(Dates_Add[Dependent Completed Dates]) || Dates_Add[Dependent Completed Dates] = ""),DATEVALUE(Dates_Add[Dependent Completed Dates]) + VALUE('Dates_Add'[# of Days]))
If I helped you and you found the solution, please kudo my messages and Accept them as the Solution. Thank you
So I have to have the date column as a date for it to work with another formula i have running. Is there a work around for me to get this one to work?
Sorry i meant i have to have it as a text***
- vojtechsima
Super User
Anonymous
If you don't wanna change the column, you can use something like this:Column = DATEVALUE(Patients_Calendar[Date]) + VALUE(Patients_Calendar[Index])
DATEVALUE takes Date value from TEXT.
VALUE takes Number values from TEXT.Now im getting this error
- vojtechsima
Anonymous
It's probably because you have empty strings there, you can check for the blanks or empty strings first and then execute otherwise do nothing:AddDate = IF ( NOT(ISBLANK(Dates_Add[Dependent Completed Dates]) || Dates_Add[Dependent Completed Dates] = ""),DATEVALUE(Dates_Add[Dependent Completed Dates]) + VALUE('Dates_Add'[# of Days]))
If I helped you and you found the solution, please kudo my messages and Accept them as the Solution. Thank you