Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

New Column

Hi, 

I have a date_column (Approved_Date), I need a new column to be created if there is a date in in Approved Date, I need value as approved in my new column.

Approved_DateNew_Column
10/10/2019Approved
nullnull
11/01/2020Approved
Need Help
  • nandu_krishna's avatar
    nandu_krishna
    6 years ago

    Anonymous 

     

    You can create calculated column.

    Column = IF(NOT(ISBLANK('Table'[Approved_Date])),"Approved")

3 Replies

  • nandu_krishna's avatar
    nandu_krishna
    Microsoft Employee
    6 years ago

    Anonymous 

     

    You can create calculated column.

    Column = IF(NOT(ISBLANK('Table'[Approved_Date])),"Approved")

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Anonymous 

    try

    New_Column = IF(ISBLANK(Table[Approved_Date]), BLANK(), Table[Approved_Date])
  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , As new column

    if(no(isblank([Approve Date]))="Approved",Blank())