table matrix - combine ?

[Anonymous]

Hi,

In the first table we have all dates in a year

In the second table we have a unique list of employees

Now we need a table that shows for each day and employee a record

With kind regards

2018-01-01

2018-01-02

etc

Thomas

Eric

etc

The result must be:

2018-01-01  Thomas

2018-01-02  Thomas

2018-01-01  Eric

2018-01-02  Eric

[v-juanli-msft · Accepted solution]

Hi @Anonymous

Modeling->New Table

enter the formula

Table = CROSSJOIN(Table1,Table2)

Best Regards

Maggie