Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Delete hours in date data

 

Hi everyone, 

 

I would like to know if it is possible to delete the hours in my completion date data? I'm not able to change anything from Power Query since I don't have the right access to the database. I tried several dax queries, but nothing works. Also, I can't delete this filter, how can I delete it if I have to use the dax query to delete the hours in my completion date data? Thanks.

 

 

 

Need Help
Tutorial Requests
  • FarhanJeelani's avatar
    FarhanJeelani
    1 year ago

    Hi Anonymous ,

    Select the Completion Date column, then navigate to the Column Tools section. Change the data type to Date, and under Format, choose your desired date format to remove the time portion.

     

     

    or 

    Create a calculated column and use this for filtering:

    CompletionDate_WithoutTime = DATE(YEAR(YourTable[CompletionDate]), MONTH(YourTable[CompletionDate]), DAY(YourTable[CompletionDate]))

     

    Please mark this post as solution if it helps you. Appreciate Kudos.

     

1 Reply

  • FarhanJeelani's avatar
    FarhanJeelani
    Super User
    1 year ago

    Hi Anonymous ,

    Select the Completion Date column, then navigate to the Column Tools section. Change the data type to Date, and under Format, choose your desired date format to remove the time portion.

     

     

    or 

    Create a calculated column and use this for filtering:

    CompletionDate_WithoutTime = DATE(YEAR(YourTable[CompletionDate]), MONTH(YourTable[CompletionDate]), DAY(YourTable[CompletionDate]))

     

    Please mark this post as solution if it helps you. Appreciate Kudos.