Forum Discussion

budderous's avatar
budderous
Regular Visitor
6 years ago
Solved

Changing a Text field to a date field

Hi   I have a column, 'next contact date' which contains a simple date in text format but also applies an NFA if there is no next contact date.   How do i convert the date field to a date without...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    In Power BI Desktop go to the home tab and click on Edit Queries.

    A new window will open with your data. Find your Date column and click on it.

    Next right click on you column and select "Replace values".

    Fill in the NFA in Value to find and replace it with 01-01-1900.

     

    The column should now be a date column, you can check this in the transform tab and look for Data Type.

    You can also manually choose your data type here.

     

    Let me know if this works

Anonymous's avatar
Anonymous
Not applicable
6 years ago

In Power BI Desktop go to the home tab and click on Edit Queries.

A new window will open with your data. Find your Date column and click on it.

Next right click on you column and select "Replace values".

Fill in the NFA in Value to find and replace it with 01-01-1900.

 

The column should now be a date column, you can check this in the transform tab and look for Data Type.

You can also manually choose your data type here.

 

Let me know if this works

budderous's avatar
budderous
Regular Visitor
6 years ago

Perfect.  Thank you very much for your help!