Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
First time poster, long time reader, so apologies if I miss something in my description.
Summary:
I want to create a unique web link in a column that contains values from other columns and the user's username for a 3rd party system, but am struggling to use the username() function as the link in each row as it can't be used in a calculated column.
Detail:
I have an application that reads data from a SQL Server DB. If the data is in a certain state, I want to create a link to our JIRA system to populate a Create Ticket page with all the relevant details. All good, except that I need to change the username in the URL to be that of the current user in Power BI.
Example table (SimulatedMainTable):
Parameter1 | Parameter2 | Parameter3 | JIRALink | UserNameMeasure |
a | b | c | http://jira.mysite.com/CreateTicket?param1=a¶m2=b&username=myusername | uk003119@site.com |
d | e | f | http://jira.mysite.com/CreateTicket?param1=d¶m2=e&username=myusername | uk003119@site.com |
Solved! Go to Solution.
Hi @pcardno
You can create a Masure like.
SELECTEDVALUE( table[hlColumn] ) & USERPRINCIPALNAME()
Hi @pcardno
You can create a Masure like.
SELECTEDVALUE( table[hlColumn] ) & USERPRINCIPALNAME()
Hi @Mariusz ,
That worked, thank you. Unfortunately, it looks like the performance of the function call when applied across a few thousand rows isn't going to work (it just hangs on more than a couple of rows in the table) but your solution did what I was asking for.
Thanks again,
Paul.
User | Count |
---|---|
73 | |
70 | |
38 | |
24 | |
23 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |