Forum Discussion
mj2024
1 year agoHelper II
Reformat datetime to only date
Hi everyone I have a table coming from sql server that is a datetime. In PowerBI I only want date not time. How do I fix this? The data is being displayed in a PowerBI table: Thank you
- 1 year ago
skparavind_1994
1 year agoFrequent Visitor
You can also try another option using the sql query
SELECT CAST('Datetime column' AS Date) AS ConvertedDate from Tablename
skparavind_1994
1 year agoFrequent Visitor
mj2024 Have you tried this solution.
If you found this answer helpful:
Mark it as the solution to help others find it faster.