Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to Solution.
@Anonymous
You can create calculated column.
Column = IF(NOT(ISBLANK('Table'[Approved_Date])),"Approved")
@Anonymous
You can create calculated column.
Column = IF(NOT(ISBLANK('Table'[Approved_Date])),"Approved")
@Anonymous , As new column
if(no(isblank([Approve Date]))="Approved",Blank())
@Anonymous
try
New_Column = IF(ISBLANK(Table[Approved_Date]), BLANK(), Table[Approved_Date])
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |