Forum Discussion
Matching different data sets based on time
Aditya Jadhav In PQ you can easily split the date and time components. First, make sure that the column is of the "Date/time" data type. Select the Date/Time column with the add column tab active. Select the Time icon, Time only. That will extract the time portion into a new column. Then do something similar with the transform column tab active. Select the Date/Time column and choose Date, Date only. That changes the column to hold only the date. Finally, select the time column (add column tab active) and select Time, Hour to create a new column with only the hour component.
PS: Wrote this answer from memory as I'm not near a computer that has Excel wit PQ on it. So perhaps, these instructions aren't 100% correct, but I trust you'll be able to figure it out.
Aditya Jadhav In PQ you can easily split the date and time components. First, make sure that the column is of the "Date/time" data type. Select the Date/Time column with the add column tab active. Select the Time icon, Time only. That will extract the time portion into a new column. Then do something similar with the transform column tab active. Select the Date/Time column and choose Date, Date only. That changes the column to hold only the date. Finally, select the time column (add column tab active) and select Time, Hour to create a new column with only the hour component.
PS: Wrote this answer from memory as I'm not near a computer that has Excel wit PQ on it. So perhaps, these instructions aren't 100% correct, but I trust you'll be able to figure it out.
One more help needed with this now. Have tried working with the raw data pulling all the tables into a PQ editor but that does not work now. The tables that are put up in the pivot and grouped for a 10 min interval is what i need but the only thing is that the data needs to be copied manually then the power query thing works like a charm. Need help in this process where the data can be copied automatically to a new table based on the date time and the value i front of it. Also have commented the required things in comments in the pivot tab.
Attaching the file for ready reference.
Regards,
Aditya
Aditya Jadhav I can see the Raw tables and the Pivot Table. You seem to connect to a file on your local drive. Not really sure what doesn't work in PQ or why and what you need further. Sorry!
