let
Source = Excel.Workbook(File.Contents("D:\test\nametest.xlsx"), null, true),
testname_DefinedName = Source{[Item="testname",Kind="DefinedName"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(testname_DefinedName, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Artist", type text}, {"Year", Int64.Type}, {"Month", type text}, {"Sales", type number}})
in
#"Changed Type"