CROSSJOIN

Creates a cartesian product by combining rows from multiple ranges.

Syntax

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

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

Remarks

  • 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.

Last updated