Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
96 | |
90 | |
79 | |
68 |
User | Count |
---|---|
151 | |
121 | |
111 | |
107 | |
95 |