Forum Discussion

eddd83's avatar
eddd83
Resolver I
6 years ago
Solved

Direct query - Remove time for date column

I am doing a direct query and in my SQL query, i'm converting a column to a date using convert(date, COLUMN). However, the data is imported into powerBI as "3/9/2020 12:00:00 AM". Since I am using a ...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi eddd83 

    yes, just pick the column, go to the Modeling (or Column tools) ribbon and select date format as you wish

     

Dan_Klunk's avatar
Dan_Klunk
Regular Visitor
1 year ago

Create a new column "= DATEVALUE(..." and reference your Date/Time column within that new column. This removes the time and, in our case, allowed the grouping by only the Date (without the Time causing separate rows for each separate Time value).