BinaryFormat.Record
This function outputs a binary format for reading a record, with the format of the record specified by the record parameter. Each field within the record may have a distinct binary format. In cases wh...
This function outputs a binary format for reading a record, with the format of the record specified by the record parameter. Each field within the record may have a distinct binary format. In cases where a field contains a value that is not in binary format, no data will be read for that particular field, and the field value will be included in the result as it is.
Parse a data record comprising of a 16-bit integer and a 32-bit integer using Power Query M language. Utilize the BinaryFormat function to define the structure of the record with an unsigned 16-bit integer and an unsigned 32-bit integer. The input binary data is specified as a hexadecimal sequence representing the integers. Execute the recordFormat function with the given binary data to extract and display the values of the integers stored in the record. The expected output after parsing the record is [A = 1, B = 2].