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

let
    Source = Table.FromRecords({
        [Product = "Apple", Price = 50],
        [Product = "Banana", Price = 30],
        [Product = "Orange", Price = 40]
    }),
    PriceList = Table.Column(Source, "Price"),
    TotalPrice = List.Sum(PriceList)
in
    TotalPrice

let
    Source = Table.FromRecords({
        [ID = 1, Email = "bob@mail.com"],
        [ID = 2, Email = "jim@mail.com"],
        [ID = 3, Email = "bob@mail.com"]
    }),
    EmailList = Table.Column(Source, "Email"),
    UniqueEmails = List.Distinct(EmailList),
    HasDuplicates = List.Count(EmailList) <> List.Count(UniqueEmails)
in
    HasDuplicates