How to remove timestamp in direct query

[Anonymous]

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

[Anonymous]

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. 

[Anonymous]

This does not fit into my requirement- the i created the column in DAX  so the column is not visible when in  power query view which is what you are pointing me to, for that resason i can not  use the function you are advising me to use to remove time stap.