CROSSJOIN

CROSSJOIN Returns a table that contains the Cartesian product of all rows from all tables in the arguments. The columns in the new table are all the columns in all the argument tables.


Syntax

CROSSJOIN(table, table[, table]…)

Parameters

table – Any DAX expression that returns a table of data

Return Value

A table that contains the Cartesian product of all rows from all tables in the arguments.


Reference Data

https://docs.microsoft.com/en-us/dax/dax-function-reference

DAX Functions / Statistical Functions / CROSSJOIN