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.

amitchandak's avatar
amitchandak
Super User
4 years ago

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

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