Power BI中ODBC导入数据的表格格式化问题求助

我已将数据通过ODBC导入Power BI，但表格格式无法满足分析需求。下图展示了当前表格状态及期望的格式效果。

当前高级编辑器代码 #

let
Source = Odbc.DataSource("driver={SQL Server};server=cmisql3\SQLEXPRESS;app=Microsoft® Windows® Operating System;database=QTD;dsn=dBASE Files", [HierarchicalNavigation=true]),
QTD_Database = Source{[Name="QTD",Kind="Database"]}[Data],
dbo_Schema = QTD_Database{[Name="dbo",Kind="Schema"]}[Data],
Results_Table = dbo_Schema{[Name="Results",Kind="Table"]}[Data]
in Results_Table

尝试的解决方案及遇到的问题 #

我尝试了一个解决方案，要求在Power Query高级编辑器中替换第一行数据并使用以下代码：

let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Added Index1" = Table.AddIndexColumn(Source, "Index", 0, 1, Int64.Type),
#"Added Custom" = Table.AddColumn(#"Added Index1", "Custom", each if Text.Contains([Column1],"24 Hr") then [Index] else null),
#"Filled Down" = Table.FillDown(#"Added Custom",{"Custom"}),
#"Removed Columns1" = Table.RemoveColumns(#"Filled Down",{"Index"}),
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Removed Columns1", {"Column1", "Custom"}, "Attribute", "Value"),
#"Pivoted Column" = Table.Pivot(#"Unpivoted Other Columns", List.Distinct(#"Unpivoted Other Columns"[Column1]), "Column1", "Value", List.Sum)
in  #"Pivoted Column"

我调整列顺序使TestName列为第一列，但出现“未找到Column1”的错误。尝试将代码中的Column1改为TestName，或把TestName列重命名为Column1，均提示对应列不存在。

内容的提问来源于stack exchange，提问作者Emily