How to adding a Date type column with text type column (containing numbers)

[Anonymous]

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

[v-xiaotang · Accepted solution]

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.

[Anonymous]

Can you please guide why you concatenated "" in the "True" condition ? Just wante dunderstand for my knowledge.

[v-xiaotang]

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.

[Anonymous]

Thank you @v-xiaotang for your support. It worked.

[amitchandak]

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

[Anonymous]

Thanks @amitchandak for your prompt answer. Please let me know how can we convert the remaining text values as null in that column.