Series, such as time series, are useful when it comes to making predictions or recognizing patterns. KQL offers a bunch of features for working with series. The following article shows how 'make-series' and 'series-fill-linear' may help you in deriving missing values from the existing ones based on interpolation.

KQL is a relatively new BI language from Microsoft and is used to retrieve data from the Azure Cloud (Azure Data Explorer / ADX and MS Fabric). This blog article shows how to call the graph engine through KQL thereby explaining 'make-graph' and 'graph-match'. The article is centered on modelling and query tasks that arise in connection with a 'Bill of Material' (BOM).

This article shows how a KQL dynamic array can be transformed to a table.