Hi,
I'm working on creating a dropdown list in one table that is dependent on another table containing employee information.
In the second table, I'd like to implement a dropdown list that dynamically populates with active employees based on the team selected in the respective row. For instance, if I choose "Team A," I want the dropdown to display options such as Jane and Joe for selection (not Daniel as he is inactive).
Any help will be apprecieted.
Try something like SELECT(Employees[Employee],AND([Team]=[_THISROW].[Team],[Status]="Active"))
User | Count |
---|---|
35 | |
31 | |
30 | |
18 | |
17 |