Forum Discussion
Need help!!
Hi, guys! I need your help. I have 2 tables (Table with rights, table with users). I know that i can connect them with power pivot many to many relationships by department and i can connect...
HI, protodimbo
you may try to use GENERATE Function to create a calculate table like below:
First you need to rename one of two column Department, for it cannot have the same column name in one table
then we rename the column Department in table2 with Department 1
then use this formula
Table = FILTER(GENERATE(Table1,Table2),Table1[Department]=Table2[Department1])
Result:
this is simple sample data
Best Regards,
Lin