Forum Discussion
Helper VRelate function or dax to refer other table
I am trying long time but I couldn't get it, count of table 1 has 1000 employees , table 2 has 600 employee, table 1 is about skills they have, table 2 is about progress they need to focus on upcoming years.
I can number of employees in table 2 as 600 My question is, I want to show 1000 employees from table 1.
- Can I know do i need to add dax or relate function,
This is my modelling tab.
Iam new to power bi..any help.pls.
5 Replies
AtchayaP what is the output you are looking for?
AtchayaP4322 associated with table 2 - has number of items and 1908 has number of employees but 47595 is the associated table of 1.
Table 1 has 47595, I want to bring same number to table 2.
v-jingzhangCommunity Support
Hi AtchayaP
Do you want to bring Table1's data into Table2? You can use the Merge queries feature in Power Query Editor. Choose one or multiple common columns like "Employee ID" in both tables as the matching colunn and merge Table1 to Table2. Power Query will look for rows with the same matching values in Table1 and bring them to Table2. You can then expand the new table column to see Table1's data.
Here are some video tutorials for your reference:
Power BI Tutorial: Merge Queries in Power Query
How to Merge Tables with Power Query: VLOOKUP Alternative
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.- AtchayaP
No, I do not have same matching columns, then how it can be achieved?
- v-jingzhang
Hi AtchayaP
Can you please show some dummy data of two tables and the expected result based on that data? In addition, what is the logic to get the expected result from the original data?
Best Regards,
Community Support Team _ Jing
