Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |