Forum Discussion

jstein91694's avatar
jstein91694
Frequent Visitor
5 years ago
Solved

Merging and Plotting Multiple DataSets with Varying Time-step Increments

Hello, I currently have created a PowerBI report with 4 different queries, each with data that increments by different timesteps (2 seconds, 1 minute, 2 minutes). I have been trying for some ti...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, jstein91694 

     

    According to your description, I think you need to rename the four columns like date,time,timestamp,record. You need to make the column names and data types of the three tables exactly the same, and then append them.

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

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

jstein91694's avatar
jstein91694
Frequent Visitor
5 years ago

I tried appending and that did not work. Below are screenshots showing the format of a couple of the datasets.

 

Note how each Time row for each dataset increments by a different amount, so the time's only match up every so often for the datasets.

 

dmf's avatar
dmf
Frequent Visitor
2 years ago

Did you ever get this resolved. I'm having a similar challenge where I have one data set that has increments of days, sometimes multiple datapoints per day. The other is basically every month. I'd like to plot both on the same graph and just connect a line between data points for the monthly while the daily can be on the X-axis.