I have two dozen tables that I need to merge into one table and the common row value, the Timestamp, has a slight variation in the seconds from table to table. Is there a way to batch change the timestamp to make the seconds null across the tables? The timestamps increase by 30 minutes across all tables otherwise. The pbix file is found here: https://filebin.net/4kxvw3rpw0efyd4g/2019-07-10_Roy_Bickell_RCA_Trends.pbix?t=6v8cdunf (New location that doesn't require Dropbox account). Thanks!

Hi matty_pants,unfortunately, you have to add a step to every table.Unless you combine all tables into one table at first and then transform the column Timestamp at once. It depends on what your next step is going to be. An example how to use the conversion:let Source = Sql.Databases("10.7.10.186\RCARCHIVE"), #"ROY BICKELL SCHOOL" = Source{[Name="ROY BICKELL SCHOOL"]}[Data], dbo_1000MTL24 = #"ROY BICKELL SCHOOL"{[Schema="dbo",Item="1000MTL24"]}[Data], TimestampWithoutSeconds = Table.TransformColumns(dbo_1000MTL24, {{"Timestamp", each #time(Time.Hour(_), Time.Minute(_), 0)}})in TimestampWithoutSeconds