Forum Discussion
How to adding a Date type column with text type column (containing numbers)
Hello,
In excel I am using a formula =IF(AY2<>"NA",(AE2+AZ2),"OPEN") to replicate the same but when I use custom column in Power BI, I am not able to do so.
I want to add a Date type ("AE") column with text type column ("AZ") (containing numbers) but power BI is returning error.
I want to add numbers mentioned in columnn AZ and increment the dates in power BI.
Please help
Hi Anonymous
You can try this, create a calculated column,
Column = IF ( 'Table'[Resolution Time] <> "NA", ( 'Table'[Logged Date] + 'Table'[Closure Days] ) & "", "OPEN" )Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
Anonymous , In power bi Closure days should be number, if there is NA value, replace that with null (all small null) in power query
and then you can simply add dates to date
Closure Date = [logged of date] +[Closure days]
Thanks amitchandak for your prompt answer. Please let me know how can we convert the remaining text values as null in that column.
Hi Anonymous
You can try this, create a calculated column,
Column = IF ( 'Table'[Resolution Time] <> "NA", ( 'Table'[Logged Date] + 'Table'[Closure Days] ) & "", "OPEN" )Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Thank you v-xiaotang for your support. It worked.
Hi Anonymous
( 'Table'[Logged Date] + 'Table'[Closure Days] ) & ""it returns a date in text format, just like the format of "open". Otherwise, an error message will appear: Expressions that yield variant data-type cannot be used to define calculated columns. More information about this error, please see this link
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
