Going crazy with a bridge (many to many) issue. I have two tables: task (task_id, task_name) and user (user_id, user_name). Since each task can be assigned to one or many users and each user can own multiple tasks, I need bridge task_user with primary keys from each user and task tables.
task table:
user table:
user_task table (bridge):
PBI relationships:
First, PBI table visual based on just user table:
Now, added task_name to the visual from task table:
The ask is this: I would like to display a list of users with a task name next to the user name. If no task is assigned to a user I would need empty string (user 3 record must be showing), if multiple tasks assigned to a user (e.g. user 1) just the the name of the first task should be shown. Something like this:
Possible? Appreciate any tips.
Thank you
