Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

#Date error conditional column

Hello everyone

I am creating a conditional column, where if the value of a column has a certain value (texttype), then bring the date I indicate, but it does not load the output type date and the error comes out #date

1 Reply

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    3 years ago

    Hi Syndicate_Admin  manuelacardonan 

     

    Your logic looks correct.  Is the issue that the new column isn't set as date type?

     

    You can just add a Change Type step, but if you wan to do it when the new column is created, you'll need to manually edit the M code.

     

    You need to add another argument to end of the Table.AddColumn function type date 

     

    = Table.AddColumn(#"Changed Type1", "Custom", each if [AnoColPaquete] = "202391" then #date(2023,3,6) else null, type date)

     

    Regards

     

    Phil