How to remove timestamp in direct query

Hi Anonymous ,

You can try copying the column (SeatDate in my case) and renaming it to SeatDate - DDMMAAAAA.

Then, outside of the powerquery editor, in the PowerBI desktop editor, I right-click on the column created by SEATDATE - DDMMAAAAA, and most importantly, in the format, I scroll and select the second option in the "Common format", called (ShortDate).

In this way I managed to get a date like "23/04/2021 13:30:45", which was only left as "23/04/2021". This allows you to continue your analysis.

You can refer to the following documents that may be helpful to you:

Solved: Convert UNIX timestamp to DateTime using Direct Qu... - Microsoft Power BI Community

PowerBI-DirectQuery - Separate Time From DateTime - Stack Overflow

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.