Forum Discussion
Solved
LOOKUPVALUE DAX with Many to Many relationship and multiple conditions
Hi, I have 2 Tables, 1. Roles 2. Access I want to create a colum in the Access table with the value of the 'Role_ID' field from the Roles table: Where 'Dept Name' field in Roles = 'Departmen...
ezFlow , You can take one value or concatenate values
new column
maxx(filter(Roles , Roles [Department] = Access [Dept Name] && Roles [RoleTitle ] = Access [Roles ]) ,Roles[Role_ID])
or
concatenatex(filter(Roles , Roles [Department] = Access [Dept Name] && Roles [RoleTitle ] = Access [Roles ]) ,Roles[Role_ID], ", ")
Thank you Amit: That worked:
new column
maxx(filter(Roles , Roles [Department] = Access [Dept Name] && Roles [RoleTitle ] = Access [Roles ]) ,Roles[Role_ID])
Do you have any souce I can read on the MAXX command and how it works?