Introducing Conversion Functions in KQL

Are you working with unit measurement data and the data is one unit and you need it another unit?


There could be many reasons that you need to convert the value, whether this is due to regional requirements or to simplify for reporting.


Great news, the Kusto team have introduced several unit conversion functions to Azure Data Explorer that will help with this.


Below you will find the list of unit conversion functions that have been added along with examples.


convert_angleConverts one angle unit to another.


Conversion units available for angles:

Arcminute, Arcsecond, Centiradian, Deciradian, Degree, Gradian, Microdegree, Microradian, Millidegree, Milliradian, Nanodegree, Nanoradian, NatoMil, Radian, Revolution, Tilt.


Example to convert from Degree to Arcminute:



convert_energy – Converts one energy unit to another.


Conversion units available for energy:

BritishThermalUnit, Calorie, DecathermEc, DecathermImperial, DecathermUs, ElectronVolt, Erg, FootPound, GigabritishThermalUnit, GigaelectronVolt, Gigajoule, GigawattDay, GigawattHour, HorsepowerHour, Joule, KilobritishThermalUnit, Kilocalorie, KiloelectronVolt, Kilojoule, KilowattDay, KilowattHour, MegabritishThermalUnit, Megacalorie, MegaelectronVolt, Megajoule, MegawattDay, MegawattHour, Millijoule, TeraelectronVolt, TerawattDay, TerawattHour, ThermEc, ThermImperial, ThermUs, WattDay, WattHour.


Example to convert from Joule to BritishThermalUnit:



convert_force – Converts one force unit into another.


Conversion units available for force:

Decanewton, Dyn, KilogramForce, Kilonewton, KiloPond, KilopoundForce, Meganewton, Micronewton, Millinewton, Newton, OunceForce, Poundal, PoundForce, ShortTonForce, TonneForce.


Example to convert from Newton to Decanewton:



convert_length – Converts one length unit to another.


Conversion units available for length:

Angstrom, AstronomicalUnit, Centimeter, Chain, DataMile, Decameter, Decimeter, DtpPica, DtpPoint, Fathom, Foot, Hand, Hectometer, Inch, KilolightYear, Kilometer, Kiloparsec, LightYear, MegalightYear, Megaparsec, Meter, Microinch, Micrometer, Mil, Mile, Millimeter, Nanometer, NauticalMile, Parsec, PrinterPica, PrinterPoint, Shackle, SolarRadius, Twip, UsSurveyFoot, Yard.


Example to convert from Meter to Foot:



convert_mass – Converts one mass unit into another.


Conversion units available for mass:

Centigram, Decagram, Decigram, EarthMass, Grain, Gram, Hectogram, Kilogram, Kilopound, Kilotonne, LongHundredweight, LongTon, Megapound, Megatonne, Microgram, Milligram, Nanogram, Ounce, Pound, ShortHundredweight, ShortTon, Slug, SolarMass, Stone, Tonne.


Example to convert from Kilogram to Pound:



convert_speed – Convert a speed value from one unit to another.


Conversion units available for speed:

CentimeterPerHour, CentimeterPerMinute, CentimeterPerSecond, DecimeterPerMinute, DecimeterPerSecond, FootPerHour, FootPerMinute, FootPerSecond, InchPerHour, InchPerMinute, InchPerSecond, KilometerPerHour, KilometerPerMinute, KilometerPerSecond, Knot, MeterPerHour, MeterPerMinute, MeterPerSecond, MicrometerPerMinute, MicrometerPerSecond, MilePerHour, MillimeterPerHour, MillimeterPerMinute, MillimeterPerSecond, NanometerPerMinute, NanometerPerSecond, UsSurveyFootPerHour, UsSurveyFootPerMinute, UsSurveyFootPerSecond, YardPerHour, YardPerMinute, YardPerSecond.


Example to convert from MeterPerSecond to CentimeterPerHour:



convert_temperature – Convert a temperature value from one unit to another.


Conversion units available for temperature:

DegreeCelsius, DegreeDelisle, DegreeFahrenheit, DegreeNewton, DegreeRankine, DegreeReaumur, DegreeRoemer, Kelvin, MillidegreeCelsius, SolarTemperature.


Example to convert from Kelvin to DegreeCelsius:



convert_volume – Convert a volume value from one unit to another.


Conversion units available for volume:

AcreFoot, AuTablespoon, BoardFoot, Centiliter, CubicCentimeter, CubicDecimeter, CubicFoot, CubicHectometer, CubicInch, CubicKilometer, CubicMeter, CubicMicrometer, CubicMile, CubicMillimeter, CubicYard, Decaliter, DecausGallon, Deciliter, DeciusGallon, HectocubicFoot, HectocubicMeter, Hectoliter, HectousGallon, ImperialBeerBarrel, ImperialGallon, ImperialOunce, ImperialPint, KilocubicFoot, KilocubicMeter, KiloimperialGallon, Kiloliter, KilousGallon, Liter, MegacubicFoot, MegaimperialGallon, Megaliter, MegausGallon, MetricCup, MetricTeaspoon, Microliter, Milliliter, OilBarrel, UkTablespoon, UsBeerBarrel, UsCustomaryCup, UsGallon, UsLegalCup, UsOunce, UsPint, UsQuart, UsTablespoon, UsTeaspoon.


Example to convert from CubicMeter to AcreFoot:




Please provide feedback if there are any additional conversion functions that you would find useful!

No Comments

Leave a Reply

SCOM Management pack for Certificate MonitoringScale security on the fly in Microsoft Azure Cloud with Cisco Secure Firewall

Contact Us

We are always here to help. Please reach out to us and we'll get back to you as soon as possible.


Maruti Court, Ground Floor
Mvuli Road, Nairobi, Kenya




Mon-Fri 8am – 5pm
Sat 9am – 1am
Sun & Holidays Closed

    Generated by Feedzy