Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Sum Data after every 30mins

Hi,   My data is in every 5 mins but I need to sum it after  every 30 mins. Please any workaround or DAX to achieve this??   See Sample Data Below:   DataTime FLOW 01/09/2017 00:00 0 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi,

Please how do I create Hour, Minute, and Date column.

How do I create a first/second half hour bucket column based on Minute column. ?/

 

Many Thanks

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Anonymous

 

See my updated reply.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi ,

     

    I've  created Hour, Minute, and Date column.

    I've also created a first/second half hour bucket column based on Minute column.

    But the resulting sum of the data is  the same value in all the 30mins intervals.

     

    DataTimeFLOW
    01/09/2017 00:002940761.6
    01/09/2017 00:002940761.6
    01/09/2017 00:002940761.6
    01/09/2017 00:002940761.6
    01/09/2017 00:002940761.6
    01/09/2017 00:002940761.6
    01/09/2017 00:002940761.6
    01/09/2017 00:002940761.6
    01/09/2017 00:002940761.6
    01/09/2017 00:002940761.6
    01/09/2017 00:002940761.6
    01/09/2017 00:002940761.6
    01/09/2017 00:002940761.6
    01/09/2017 00:002940761.6
    01/09/2017 00:002940761.6
    01/09/2017 00:002940761.6
    01/09/2017 00:002940761.6
    01/09/2017 00:002940761.6
    01/09/2017 00:002940761.6
    01/09/2017 00:002940761.6
    01/09/2017 00:002940761.6
    01/09/2017 00:002940761.6
    01/09/2017 00:002940761.6
    01/09/2017 00:002940761.6
    01/09/2017 00:002940761.6

     

    I've sent the pbix file to your mail.

     

    Many Thanks for your help

     
    • v-sihou-msft's avatar
      v-sihou-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Anonymous

       

      I don't find any issue in your .pbix, it shows same total under each "Half Hour" (Your Minute column is based on DateTimePrevious, not DateTime) which is correct. 

       

       

      Regards,

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi,

         

        As mentioned,  I want my resulting data/chart to respond when i click a  slicer in my visual.

         

        I want to be able to click a slicer, select a day in my first graph(stacked column) and the second graph (Line Graph) with the 'Sum Data after every 30mins' responds appropriately to the particlar day selected.

        The 'Half Hourly Total' is not reponding when a particular slicer is selected.

        Please where can i send you the PBIX file??

        See how I want my graph to display