Issue with Action Date/Time Display after implementing code in query editor

[Jack_Reacher]

I'm fairly new to Power BI, and I'm encountering an issue with the display of the "Action Date/Time" column in my Power BI report and seeking any helpful suggestions on how to resolve it.

Here's a breakdown of the problem and the relevant data:

The table is related to tickets assigned by two people to different technicians. The "Action Date/Time" column is displaying the date and time when the ticket was returned by the technician to the person who can then either send it back to the technician or close it. In my Power BI report is not displaying the correct dates for occurrences of actions taken on tickets. Despite having the correct raw data, the displayed dates in the report after implementing the query editor are inaccurate.

Results in Power BI (Incorrect): 

Any insights or suggestions on how to correct this issue would be greatly appreciated

[v-jingzhan-msft]

Hi @Jack_Reacher 

I'm not able to access the sample file and sample data due to some network restrictions. If possible, can you paste some snippet of sample data in the reply? Sorry for this inconvenience.

Best Regards,
Jing

[Jack_Reacher]

Hello Jin, can you please try accessing the link again ?
https://drive.google.com/drive/folders/15OSktBbdm8rnZnSjzNilRWuz4tFpC3Pv?usp=drive_link

[v-jingzhan-msft]

Unfortunately my network blocks some cloud file services and googledrive is one of them😥

Perhaps you can capture a screenshot to show how the raw data looks like (mask or remove sensitive data). Or paste some sample data of one or two tickets. I guess you are creating a table visual in the report and it seems to display one ticket at a time. So one or two tickets' data is probably enough. 

[Jack_Reacher]

@v-jingzhan-msft  Yes no worries, please try this  link https://app.nihaoconsult.com/u/d/5d8b0fe3fd9b4d5cb601/

Otherwise, you may find the screenshot below