New DAX Functions

Question 1

PARTITIONBY ( partitionBy_columnName[, partitionBy_columnName [, …] ] )

Answer 1

Defines the columns that are used to partition a window function’s <relation> parameter.</relation>

Question 2

ORDERBY ( orderBy_columnName[, order][, orderBy_columnName [, order]] [, …] )

Answer 2

Defines the columns that determine the sort order within each of a window function’s partitions.

Question 3

INDEX(position[, relation][, orderBy][, blanks][, partitionBy])

Answer 3

Returns a row at an absolute position, specified by the position parameter, within the specified partition, sorted by the specified order. If the current partition can’t be deduced to a single partition, multiple rows may be returned.

Question 4

OFFSET ( delta[, relation][, orderBy][, blanks][, partitionBy] )

Answer 4

Returns a single row that is positioned either before or after the current row within the same table, by a given offset. If the current row cannot be deduced to a single row, multiple rows may be returned.

Question 5

TOCSV(Table, [MaxRows], [Delimiter], [IncludeHeaders])

Answer 5

Returns a table as a string in CSV format.

Question 6

TOJSON(Table, [MaxRows])

Answer 6

Returns a table as a string using JSON format.

Question 7

WINDOW ( from[, from_type], to[, to_type][, relation][, orderBy][, blanks][, partitionBy] )

Answer 7

Returns multiple rows which are positioned within the given interval.

Question 8

NETWORKDAYS(start_date, end_date[, weekend, holidays])

Answer 8

Returns the number of whole workdays between two dates (inclusive). Parameters specify which and how many days are weekend days. Weekend days and days specified as holidays are not considered as workdays.

Question 9

EVALUATEANDLOG(Value, [Label], [MaxRows])

Answer 9

Returns the value of the first argument and logs it in a DAX Evaluation Log profiler event. This function is fully functional in Power BI Desktop only. It acts as a simple passthrough function in other environments.

Question 10

LINESTX ( table, expressionY, expressionX[, …][, const] )

Answer 10

Uses the Least Squares method to calculate a straight line that best fits the given data, then returns a table describing the line. The data result from expressions evaluated for each row in a table. The equation for the line is of the form: y = Slope1x1 + Slope2x2 + … + Intercept.