Sparkline is a chart that is located inside the cell and shows the change in value over a given period of time, and is suitable for observing trends. It can be a Column or Line chart. This way of presenting data has been in Excel since version 2010, and has recently become available within the Power BI Desktop reporting platform. In the text that follows, you will find out how it is added and changed …
This is a logical function used as an argument by the LAMBDA function, and it aims to check if any of the arguments have been omitted. When using the LAMBDA function, it is mandatory to provide as many arguments as initially given. Since it returns the value TRUE or FALSE it is used in combination with the IF function in the part of the LAMBDA function where it is necessary to specify the value it returns.
The BYROW and BYCOL functions are used to perform a calculation given by a LAMBDA function that uses only one argument for a given row or column. This, in a way, distinguishes them from the function mentioned in the previous post. Both functions work in a similar way. They differ only in whether they retrieve the data needed for the calculation from the row or column.
MAKEARRAY allows you to easily generate an array (range) of values. The first two arguments are the number of rows and columns, and further should specify the expression within which the calculation is performed using the LAMBDA function. This function is also dynamic in nature because it does not return a single value but a range in accordance with the given dimensions.
The SCAN function is used to search an array (range) and return the calculated value based on a formula specified using the LAMBDA function. The first, optional argument, is the initial value. It is often left out. Then we specify an array (range) and at the end we state the mentioned expression by which the calculation is performed. The result of this function is not one value but a range whose dimensions correspond to a given sequence.