Forum Discussion
Cannot convert value '' of type Text to type Number.
I have a column that is a date but is in Text format and i have another column that is a text format as well. Im trying to add them both together into a seperate column to show new dates I dont u...
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
vojtechsima
Super User
Super UserAnonymous
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
This worked! Thank you so much!
- vojtechsima
Anonymous
Happy to help.