Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago
Solved

Null date fields

What is the best way to impersonate null data in a Datetime column?
  • Anonymous's avatar
    Anonymous
    3 years ago

    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's avatar
djurecic
Super User
3 years ago

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.