# CROSSJOIN

#### Syntax <a href="#syntax" id="syntax"></a>

**CROSSJOIN**(*range1*; *range2*; ...; *rangeN*)

* *range1, range2, ..., rangeN* - the ranges to be combined - ***Value type**: range of any value*

#### Remarks <a href="#remarks" id="remarks"></a>

* The function returns a row-wise cartesian product combination of all rows from all specified ranges.
* Each row of the first range is combined with each row of all other ranges, resulting in a complete set of all possible combinations.
* This function is useful for creating master templates with all possible combinations of dimensions, generating complete date lists for periods, creating permutations for testing, or generating hierarchical reporting structures.