Value.Subtract Function of Power Query

The Value.Subtract function returns the difference of the two values. i.e Value1 - Value2.

Syntax

Value.Subtract(value1 as any, value2 as any, optional precision as nullable number) as any

Example:

Power Query M

let
  MyTable = Table.FromRecords(
    {
      [EmployeeID = 1, Name = "Ashish", Science_Marks = 56, Math_Marks=65],
      [EmployeeID = 2, Name = "Katrina", Science_Marks = 130, Math_Marks=65],
      [EmployeeID = 3, Name = "Alia", Science_Marks = 38, Math_Marks=65],
      [EmployeeID = 4, Name = "Vicky", Science_Marks = 48, Math_Marks=90],
      [EmployeeID = 5, Name = "Mohini", Science_Marks = 28, Math_Marks=0],
      [EmployeeID = 6, Name = "Meenakshi", Science_Marks = -29, Math_Marks=65],
      [EmployeeID = 7, Name = "Esha", Science_Marks = 100, Math_Marks=50],
      [EmployeeID = 8, Name = "Anjali", Science_Marks = 0, Math_Marks=38]
    }
  ), 
  return = Table.AddColumn(MyTable, "Subtract result", (_) => Value.Subtract(_[Science_Marks], _[Math_Marks]))
in
  return

The output of the above code is shown below:

Previous Next