Cannot convert value '' of type Text to type Number.

[Anonymous]

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 understand why i keep getting the error above even after i change the data type to date or number and back to text. 

This is the formula im using. 

Calculated Deadline = 'Table_Name (Calc)'[Dependent Completed Dates] + 'Table_Name (Calc)'[# of Days]

[vojtechsima]

Hi, @Anonymous 
If you want to add two strings (text) together you have to use this symbol & (instead of +) or function called:

CONCATENATE

[Anonymous]

Im attempting to add these two 

[vojtechsima]

Hi, @Anonymous ,
Make sure Date column is Date and # of Days is a number, then creating new Column should work like this:

Column = Patients_Calendar[Date] + Patients_Calendar[Index]

[Anonymous]

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? 

[Anonymous]

Sorry i meant i have to have it as a text*** 

[vojtechsima]

@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. 

[Anonymous]

Now im getting this error 

[vojtechsima · Accepted solution]

@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

[Anonymous]

This worked! Thank you so much!

[vojtechsima]

@Anonymous 
Happy to help.