Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Issues with Change type to Date/Time

hi,   i am trying to change the type of a date/time column to a consistant format but i get errors when i change the type to a date or date/time in Power Query Editor i get this error   Da...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    i worked out an easier solution

     

    since i do not need the AEDT, or AEST text i removed them in advanced query editor

     

    1. Duplicated Column (to not lose any data but not necessary)

    2. Right click on column and select Replaced Values
    3. Inserted AEDT in "Value to Find" and left "Replace with" as blank

    4. Right click on column and select Replaced Values

    5. Inserted AEST in "Value to Find" and left "Replace with" as blank

    6. Changed Type to Date/Time

     

    since all values now have a date & time i can use that in my graphs with no troubles now

     

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

Share the link from where i can download your PBI file.

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Ashish_Mathur wrote:

Hi,

 

Share the link from where i can download your PBI file.

 

is there another way, i cannot provide you with the file as it has some highly confidential data?

 

thanks