Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Group data by time and date

I have data for multiple months, i have the data in like monthly batches and appended together. I want to group the data from like (dd/mm/yyyy) 01/01/2022 10.00.00am to 01/02/2022 09.59.59am instead of them being group like by the month from like 01/01/2022 00.00.00am to 31/01/2022 23.59.59.

Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , In power query you can add new column like

    Date.StartOfMonth(DateTime.Date([Confirm DT]))

     

    I have given DAX formula before

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , You can create a month start date

     

    Start Date = eomonth([Date],-1) +1

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      so the data column looks like this

       

      I do not know how to do the step that u mentioned previously, could u show and example?

       

      • amitchandak's avatar
        amitchandak
        Super User
        4 years ago

        Anonymous , In power query you can add new column like

        Date.StartOfMonth(DateTime.Date([Confirm DT]))

         

        I have given DAX formula before