Table.SelectRows – กรองแถวตามเงื่อนไขใน Power Query

let
    Sales = Table.FromRecords({
        [OrderID = 1, CustomerName = "Alice", Amount = 500],
        [OrderID = 2, CustomerName = "Bob", Amount = 1500],
        [OrderID = 3, CustomerName = "Charlie", Amount = 800],
        [OrderID = 4, CustomerName = "Diana", Amount = 2200]
    }),
    HighValueOrders = Table.SelectRows(Sales, each [Amount] > 1000)
in
    HighValueOrders

let
    Products = Table.FromRecords({
        [ProductID = "P001", Category = "Electronics", Price = 15000],
        [ProductID = "P002", Category = "Food", Price = 200],
        [ProductID = "P003", Category = "Electronics", Price = 8000],
        [ProductID = "P004", Category = "Clothing", Price = 1200]
    }),
    ElectronicsOnly = Table.SelectRows(Products, each [Category] = "Electronics")
in
    ElectronicsOnly

let
    Orders = Table.FromRecords({
        [OrderID = 101, Status = "Complete", Amount = 1200, Email = "alice@example.com"],
        [OrderID = 102, Status = "Pending", Amount = 800, Email = null],
        [OrderID = 103, Status = "Complete", Amount = 500, Email = "charlie@example.com"],
        [OrderID = 104, Status = "Complete", Amount = 1500, Email = "diana@example.com"],
        [OrderID = 105, Status = "Cancelled", Amount = 2000, Email = "eve@example.com"]
    }),
    ValidHighValueOrders = Table.SelectRows(
        Orders,
        each [Status] = "Complete" and [Amount] > 1000 and [Email] <> null
    )
in
    ValidHighValueOrders

let
    Transactions = Table.FromRecords({
        [TransID = "TXN-2024-001", CustomerName = "ABC Company Ltd.", Date = #date(2024, 3, 15), Amount = 5000],
        [TransID = "TXN-2024-002", CustomerName = "John Doe", Date = #date(2024, 6, 20), Amount = 1200],
        [TransID = "TXN-2024-003", CustomerName = "XYZ Corporation", Date = #date(2024, 9, 10), Amount = 8500],
        [TransID = "TXN-2023-999", CustomerName = "Smith & Co.", Date = #date(2023, 12, 5), Amount = 3000]
    }),
    FilteredTransactions = Table.SelectRows(
        Transactions,
        each Text.Contains([CustomerName], "Company") or Text.Contains([CustomerName], "Corporation")
             and Date.Year([Date]) = 2024
             and [Amount] >= 5000
    )
in
    FilteredTransactions