Forum Discussion

JrKoh's avatar
JrKoh
Frequent Visitor
4 years ago
Solved

Downsampling data

Hi all,   I want to downsample my data from every second to every minute/hour. I have splitted the Date and Time from DateTime and tried grouping it by per min/hour but I cannot figure out how to s...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi JrKoh ,

     

    You can create a calculated column like

     

     

    Time = TIME(HOUR([DateTime]),MINUTE([DateTime]),0)

     

     

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • JrKoh's avatar
    JrKoh
    4 years ago

    Hi Stephen,

    With your solution in mind, I found a way to downsample the data. I created 2 calculated column, Time_1min and Time_H and wrote another DAX measure and put it into the chart filter. I then key in the number into the filter to determine which sampling:

     

    Downsample =
    SWITCH(
    TRUE(),
    SUM(Sensor[Time]) == SUM(Sensor[Time_H]),1,
    SUM(Sensor[Time]) == SUM(Sensor[Time_1min]),3
    )

     

    per hour
     

    per min

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi JrKoh ,

 

You can create a calculated column like

 

 

Time = TIME(HOUR([DateTime]),MINUTE([DateTime]),0)

 

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • JrKoh's avatar
    JrKoh
    Frequent Visitor
    4 years ago

    Hi Stephen,

    With your solution in mind, I found a way to downsample the data. I created 2 calculated column, Time_1min and Time_H and wrote another DAX measure and put it into the chart filter. I then key in the number into the filter to determine which sampling:

     

    Downsample =
    SWITCH(
    TRUE(),
    SUM(Sensor[Time]) == SUM(Sensor[Time_H]),1,
    SUM(Sensor[Time]) == SUM(Sensor[Time_1min]),3
    )

     

    per hour
     

    per min