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, I have 1 table with multiple columns. One column is a unique Ticket ID. I need to create a new column which will create a url for each record. the url needs to be of the format http://urladdress="ticket ID"&ticket="ticketID"
so if the ticket id happened to be 222 the url I would need would be
http://urladdress=222&ticket=222
hopefully that makes sense?
the URL will always be exactly the same, but obviously the ticket ID will change for each row.
Thank You in advance
Solved! Go to Solution.
Hi,
Create this calculated column formula
="http://urladdress="&[ticket id]&"&ticket="&[ticket id]
Hope this helps.
Hi,
Create this calculated column formula
="http://urladdress="&[ticket id]&"&ticket="&[ticket id]
Hope this helps.
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |