Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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") ...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    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's avatar
Anonymous
Not applicable
4 years ago

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

v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

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.