New Column

[Anonymous]

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_Date	New_Column
10/10/2019	Approved
null	null
11/01/2020	Approved

[nandu_krishna · Accepted solution]

@Anonymous 

You can create calculated column.

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

[amitchandak]

@Anonymous , As new column

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

[az38]

@Anonymous 

try

New_Column = IF(ISBLANK(Table[Approved_Date]), BLANK(), Table[Approved_Date])