Forum Discussion
How to remove timestamp in direct query
I have date column that i need to remove timestamp on. I have tried FORMAT funnction but it does work on a Direct query which is what i am using. Just for a little bit of a back ground, i am using this dataset for my Paginated report in report builder and whne i bring the column in report builder it has time stamp. any suggestions on how to remove the time stamp will be appreciated a lot
2 Replies
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.