Forum Discussion
Solved
Null date fields
What is the best way to impersonate null data in a Datetime column?
Hi Syndicate_Admin ,
Here are the steps you can follow：
1. Create calculated column.
Column = IF( ISBLANK('Table'[FechainicioPollza]),TODAY(),[FechainicioPollza])2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
2 Replies
Not sure if this is the best solution, but you could replace Null values with the same value that does not exist anywhere else in the dataset, like 1/1/2000 then filter out that value.
Hi Syndicate_Admin ,
Here are the steps you can follow：
1. Create calculated column.
Column = IF( ISBLANK('Table'[FechainicioPollza]),TODAY(),[FechainicioPollza])2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
