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! Learn more
 
					
				
		
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.
 
            | User | Count | 
|---|---|
| 84 | |
| 49 | |
| 35 | |
| 31 | |
| 30 |