Power Query
Search…
published
Introduction
Accessing Data
Action
Binary
Binary Formats
Combiner
Comparer
Cube
Date
Date Time
Date Time Zone
Diagnostics
Duration
Error
Expression
Function
Lines
List
Logical
Metadata
Number
Record
Replacer
Splitter
Table
Text
Time
Type
Uri
Values
DirectQueryCapabilities.From
Embedded.Value
Html.Table
Pdf.Tables
Resource.Access
SqlExpression.SchemaFrom
SqlExpression.ToExpression
Value.Add
Value.As
Value.Compare
Value.Divide
Value.Equals
Value.Firewall
Value.Is
Value.Multiply
Value.NativeQuery
Value.NullableEquals
Value.ReplaceType
Value.ResourceExpression
Value.Subtract
Value.Type
Variable.Value
Web.BrowserContents
Powered By GitBook
Value.Compare

Value.Compare

Returns -1, 0, or 1 based on whether the first value is less than, equal to, or greater than the second one.
function (optional value1 as nullable any, optional value2 as nullable any, optional precision as nullable any) as number

Description

Returns -1, 0, or 1 based on whether the first value is less than, equal to, or greater than the second one.

Category

Values
Previous
Value.As
Next
Value.Divide
Last modified 3yr ago
Copy link
Contents
Value.Compare
Description
Category