Record.TransformFields

 

This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.

Transforms fields by applying transformOperations. For more more information about values supported by transformOperations, see Parameter Values.

Record.TransformFields(record as record,  transformOperations as list,  optional missingField as nullable number) as record  

ArgumentDescription
recordThe Record to modify.
transformOperationsThe list of transformations to make.
optional missingFieldA MissingField enum value to handle missing fields. The default value is MissingField.Error.

MissingField enum

MissingField.Error = 0;  

MissingField.Ignore = 1;  

MissingField.UseNull = 2;  

Record.TransformFields([OrderID = 1, CustomerID= 1, Item = "Fishing rod", Price = "100.0"], {"Price", Number.FromText})  

equals [OrderID =1, CustomerID  =1, Item = "Fishing rod", Price=100 ]  

OrderID1
CustomerID1
ItemFishing rod
Price100
Record.TransformFields(  

[OrderID ="1", CustomerID= 1, Item = "Fishing rod", Price = "100.0"],  

{{"OrderID", Number.FromText}, {"Price",Number.FromText}})  

equals [OrderID =1, CustomerID  =1, Item = "Fishing rod", Price=100 ]  

OrderID1
CustomerID1
ItemFishing rod
Price100
Show: