PowerQuery M Reference Guide
Accessing data functions
Binary functions
Binary.Buffer
Binary.Combine
Binary.Compress
Binary.Decompress
Binary.From
Binary.FromList
Binary.FromText
Binary.InferContentType
Binary.Length
Binary.Range
Binary.ToList
Binary.ToText
BinaryEncoding.Base64
BinaryEncoding.Hex
BinaryFormat.7BitEncodedSignedInteger
BinaryFormat.7BitEncodedUnsignedInteger
BinaryFormat.Binary
BinaryFormat.Byte
BinaryFormat.ByteOrder
BinaryFormat.Choice
BinaryFormat.Decimal
BinaryFormat.Double
BinaryFormat.Group
BinaryFormat.Length
BinaryFormat.List
BinaryFormat.Null
BinaryFormat.Record
BinaryFormat.SignedInteger16
BinaryFormat.SignedInteger32
BinaryFormat.SignedInteger64
BinaryFormat.Single
BinaryFormat.Text
BinaryFormat.Transform
BinaryFormat.UnsignedInteger16
BinaryFormat.UnsignedInteger32
BinaryFormat.UnsignedInteger64
BinaryOccurrence.Optional
BinaryOccurrence.Repeating
BinaryOccurrence.Required
ByteOrder.BigEndian
ByteOrder.LittleEndian
Compression.Brotli
Compression.Deflate
Compression.GZip
Compression.LZ4
Compression.None
Compression.Snappy
Compression.Zstandard
Occurrence.Optional
Syntax
About
Occurrence.Repeating
Occurrence.Required
#binary
Combiner functions
Comparer functions
Date functions
DateTime functions
DateTimeZone functions
Duration functions
Error handling
Expression functions
Function values
Lines functions
List functions
Logical functions
Number functions
Record functions
Replacer functions
Splitter functions
Table functions
Text functions
Time functions
Type functions
Uri functions
Value functions
PowerQuery M Reference Guide
»
Binary functions
»
Occurrence.Optional
View page source
Occurrence.Optional
Microsoft Docs:
Occurrence.Optional
Syntax
Syntax
for
this
function
.
About
About this function.