CROSSJOIN – all combinations of two lists (DAX – Power Pivot, Power BI)
The CROSSJOIN function creates table, showing all possible combinations of values from two other tables.
For example from these two tables:
you can create a third table, showing all combinations - to merge everything with everything.