Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
dear all,
i have two tables in power query
| Year | month |
| 2019 | 1 |
| 2019 | 2 |
| 2019 | 3 |
| 2019 | 4 |
| 2019 | 5 |
| 2019 | 6 |
| 2019 | 7 |
| 2019 | 8 |
| 2019 | 9 |
| 2019 | 10 |
| 2019 | 11 |
| 2019 | 12 |
and
| EmployeeID |
| a1 |
| a2 |
| a3 |
| a4 |
I would like to join these so that the employeeid returns every month of the year: requested table (For first 3 months only):
| year | month | employeeID |
| 2019 | 1 | a1 |
| 2019 | 1 | a2 |
| 2019 | 1 | a3 |
| 2019 | 1 | a4 |
| 2019 | 2 | a1 |
| 2019 | 2 | a2 |
| 2019 | 2 | a3 |
| 2019 | 2 | a4 |
| 2019 | 3 | a1 |
| 2019 | 3 | a2 |
| 2019 | 3 | a3 |
| 2019 | 3 | a4 |
Solved! Go to Solution.
@Anonymous
In the first Table (Say Table1) you can add a custom column
=Table2
Then expand it to new rows
@Anonymous
In the first Table (Say Table1) you can add a custom column
=Table2
Then expand it to new rows
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.