Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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.

scorpene_0-1643219548593.png

 

Please help

1 ACCEPTED SOLUTION
v-xiaotang
Community Support
Community Support

Hi @Anonymous 

You can try this, create a calculated column,

Column =
IF (
    'Table'[Resolution Time] <> "NA",
    ( 'Table'[Logged Date] + 'Table'[Closure Days] ) & "",
    "OPEN"
)

vxiaotang_0-1643704034835.png

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.

View solution in original post

6 REPLIES 6
v-xiaotang
Community Support
Community Support

Hi @Anonymous 

You can try this, create a calculated column,

Column =
IF (
    'Table'[Resolution Time] <> "NA",
    ( 'Table'[Logged Date] + 'Table'[Closure Days] ) & "",
    "OPEN"
)

vxiaotang_0-1643704034835.png

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
Not applicable

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

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

vxiaotang_0-1643872373539.png

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
Not applicable

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

amitchandak
Super User
Super User

@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
Not applicable

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.