Need help!!

[protodimbo]

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 it with DAX formulas. I need to make report table where i can see who have access to any folder and what rights he has and in what department he work etc.

Please help me

[v-lili6-msft]

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

[protodimbo]

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 it with DAX formulas. I need to make report table where i can see who have access to any folder and what rights he has and in what department he work etc.

Please help me