Single and Multi Line Comments in Power Query Advanced Editor

Just a simple reminder on how to do single and multiple line comments

me@jaykilleen.com wrote this about 7 years ago and it was last updated about 7 years ago.


← Back to the Posts


  let
    //SINGLE LINE COMMENT
    Source = Text.Proper("hello world")
  in
    Source


  /* MULTI LINE COMMENTS
  is evaluated for each Item in each table row. */
  let
    Orders = Table.FromRecords({
      [OrderID = 1, CustomerID = 1, Item = "fishing rod", Price = 100.0],
      [OrderID = 2, CustomerID = 1, Item = "1 lb. worms", Price = 5.0],
      [OrderID = 3, CustomerID = 2, Item = "fishing net", Price = 25.0]}),
      #"Capitalized Each Word" = Table.TransformColumns(Orders, {"Item", Text.Proper})
  in
      #"Capitalized Each Word"

Similar