Forum Discussion

MNGoodyear's avatar
MNGoodyear
Frequent Visitor
6 years ago

Data and Time manipulation

I have a data set as a direct query from a SQL database.

 

This includes a Date time field as shown below: 

 

I would like to use the value as just a date field in in a graph, I have tried changing the format to just date but the x axis still displays the time

 

I also want to group the date time by 15 minute groupings for another graph but unsure how to achieve.

 

Any help would be appreciated

 

DAX

3 Replies

    • MNGoodyear's avatar
      MNGoodyear
      Frequent Visitor
      6 years ago

      Hi,

      I followed your instructions and have created a time table, this allows me to allocate a time slot to production. I can then graph this, however what this doesn't show me is the points of zero production.

      For example if i plot the below data it will not show 0 for the 30 minute slots between 12:30 and 1:30 and i would like to sum every time slot between 7am and 7 pm and display zero where no production: 

       

      date_timecodeQtyWL_BarcodeSlotHour
      11/08/2020 12:19Apple110-2912
      11/08/2020 12:19Apple120-2912
      11/08/2020 12:19Apple130-2912
      11/08/2020 12:19Apple140-2912
      11/08/2020 12:20Apple150-2912
      11/08/2020 12:20Apple160-2912
      11/08/2020 12:23Apple170-2912
      11/08/2020 12:23Apple180-2912
      11/08/2020 12:28Apple190-2912
      11/08/2020 12:28Apple1100-2912
      11/08/2020 13:31Apple11130-5913
            

       

      Thanks