let
    Source = Table.FromRecords({
        [CustomerID = 1, Name = "Bob", Sales = 100],
        [CustomerID = 2, Name = "Jim", Sales = 200],
        [CustomerID = 3, Name = "Paul", Sales = 300]
    }),
    Result = Table.ColumnCount(Source)
in
    Result

let
    Source = Excel.CurrentWorkbook(){[Name="SalesData"]}[Content],
    ColumnCount = Table.ColumnCount(Source),
    Message = if ColumnCount = 5 then "โครงสร้างถูกต้อง" else "โครงสร้างไม่ตรง!"
in
    Message

let
    Source = Table.FromRecords({
        [A = 1, B = 2],
        [A = 3, B = 4]
    }),
    RowCount = Table.RowCount(Source),
    ColCount = Table.ColumnCount(Source),
    TotalCells = RowCount * ColCount
in
    TotalCells