Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Solved! Go to 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
Hi, @Anonymous
If you want to add two strings (text) together you have to use this symbol & (instead of +) or function called:
CONCATENATE
Im attempting to add these two
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]
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***
@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
@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
This worked! Thank you so much!
@Anonymous
Happy to help.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
93 | |
90 | |
84 | |
70 | |
49 |
User | Count |
---|---|
141 | |
120 | |
112 | |
60 | |
58 |