Null date fields

[Syndicate_Admin]

What is the best way to impersonate null data in a Datetime column?

[Anonymous · Accepted solution]

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

[djurecic]

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.