DAX - Table Manipulation Functions questions (updated & already graded A+).

DAX - Table Manipulation
Functions questions 2025-
2026(updated & already
graded A+)
ADDCOLUMNS


ADDCOLUMNS(<table>, <name>, <expression>[, <name>,
<expression>]...) - answer Adds calculated columns to the
given table or table expression. Returns a table with all its
original columns and the added ones.


This function is not supported for use in DirectQuery mode
when used in calculated columns or row-level security
(RLS) rules.


ADDMISSINGITEMS


ADDMISSINGITEMS ( [<showAll_columnName> [,
<showAll_columnName> [, ... ] ] ], <table> [,
<groupBy_columnName> [, [<filterTable>] [,
<groupBy_columnName> [, [<filterTable>] [, ... ] ] ] ] ] ] ) -
answer Adds combinations of items from multiple columns
to a table if they do not already exist.


<table> A table returned by SUMMARIZECOLUMNS

, This function is not supported for use in DirectQuery mode
when used in calculated columns or row-level security
(RLS) rules.


CROSSJOIN


CROSSJOIN(<table>, <table>[, <table>]...) - answer
Returns a table that contains the Cartesian product of all
rows from all tables in the arguments.


The total number of rows is a product of the number of
rows from each table. The number of columns is a sum of
all the columns.


This function is not supported for use in DirectQuery mode
when used in calculated columns or row-level security
(RLS) rules.


CURRENTGROUP


CURRENTGROUP ( ) - answer Returns a set of rows from
the table argument of a GROUPBY expression.


DATATABLE


DATATABLE (ColumnName1, DataType1, ColumnName2,
DataType2..., {{Value1, Value2...}, {ValueN,
ValueN+1...}...}) - answer Provides a mechanism for
declaring an inline set of data values.