Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
It is possible to creat a measure off mailto: whit the mail adress being dynamic created based on client and team.
I have this 3 tables and are linked between them whit relationships.
Is that possible to creat the link mailto: dynamically depending on client and team?
Project table
project | client | team |
project_1 | client_1 | team_1 |
project_2 | client_2 | team_3 |
project_3 | client_3 | team_1 |
project_4 | client_1 | team_4 |
client table
client | client mail |
client_1 | cliente_1_user1; client_1_user_2; client_1_user3; |
client_2 | client_2_user1; |
client_3 | client_3_user1; cliente_3_user2; |
and team table
team | team member's |
team_1 | user_1; user_2; |
team_2 | user_3; user_4; |
team_3 | user_1; user_5; |
team_4 | user_6; |
Hi @wolfy_ ,
The best way is to unpivot team table and client table. Let the table looks like this:
team | team member's |
team_1 | user_1 |
team_1 | user_2 |
team_2 | user_3 |
team_2 | user_4 |
team_3 | user_1 |
team_3 | user_5 |
team_4 | user_6 |
Then use function CONCATENATE() or CONCATENATEX() to get the result.
But what the link looks like?
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, the link would be a mailto: so when I click on the projectID link it will open a new mail whit all the necessary parties, client, and team menbers mail's
User | Count |
---|---|
101 | |
90 | |
82 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |