Jump to content
One on One Extensive Advanced Excel Training ×
Business Intelligence & Analytics for Digital Transformation

Saurabh Jain

Administrators
  • Posts

    1,724
  • Joined

  • Last visited

  • Days Won

    61

Everything posted by Saurabh Jain

  1. Replaces the metadata on a value with the new metadata record provided and returns the original value with the new metadata attached.
  2. Removes the metadata on the value and returns the original value.
  3. Returns a record containing the input’s metadata.
  4. Replaces the value's type.
  5. Saurabh Jain

    Value.Is

    Determines whether a value is compatible with the specified type.
  6. Saurabh Jain

    Value.As

    Returns the value if it is compatible with the specified type.
  7. Returns the difference of the two values.
  8. Returns the product of the two values.
  9. Returns the result of dividing the first value by the second.
  10. Returns the sum of the two values.
  11. Returns the type of the given value.
  12. If value represents a query that can be optimized, returns the optimized query. Otherwise returns value.
  13. Returns a logical value or null based on two values .
  14. Evaluates a query against a target.
  15. Returns a navigation table containing the available versions of a value.
  16. Returns the version identity of a value.
  17. Returns an abstract syntax tree (AST) that represents the value's expression.
  18. Returns whether two values are equal.
  19. Returns 1, 0, or -1 based on value1 being greater than, equal to, or less than the value2. An optional comparer function can be provided.
  20. Expresses alternate query plans.
  21. Returns a record value with the fields set to the parts of a Uri text value.
  22. Encodes special characters in accordance with RFC 3986.
  23. Returns a Uri based on the combination of the base and relative parts.
  24. Assemble a record into a URI query string.
  25. Returns the union of a list of types.
×
×
  • Create New...