Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi @Norbertus
Modeling->New Table
enter the formula
Table = CROSSJOIN(Table1,Table2)
Best Regards
Maggie
Hi @Norbertus
Modeling->New Table
enter the formula
Table = CROSSJOIN(Table1,Table2)
Best Regards
Maggie
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |