查询M语言计算

= 1 + 2

= 5 - 3

= 4 * 6

= 10 / 2

= "Hello, " & "World!"

= Text.Length("Hello, World!")

= Text.Middle("Hello, World!", 7, 5)

= DateTime.LocalNow()

= DateTime.AddMonths(DateTime.LocalNow(), 1)

= DateTime.ToText(DateTime.LocalNow(), "yyyy-MM-dd")

= Text.Lower("Hello, World!")

= Text.Upper("Hello, World!")

= Text.Replace("Hello, World!", "World", "Power BI")

= if 1 > 2 then "True" else "False"

= if 1 > 2 then "A" else if 2 > 1 then "B" else "C"

= List.Sum({1, 2, 3, 4, 5})

= List.Average({1, 2, 3, 4, 5})

= List.Max({1, 2, 3, 4, 5})

= List.Min({1, 2, 3, 4, 5})

= List.Select({1, 2, 3, 4, 5}, each _ > 2)

= Table.SelectRows(Table.FromRecords({[Name = "Alice", Age = 30], [Name = "Bob", Age = 25]}), each [Age] > 25)