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
Sorry i meant i have to have it as a text***
Super UserAnonymous
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 youThis worked! Thank you so much!