Create a dynamic URL with data from a paramater and table

Is there an efficient way to dynamically create a URL that a user can throw into table where they can follow the generated links?  My first attempt at this generates a URL but it is incredibly inefficient and takes forever to load if the client has a medium/large data footprint.

I currently have a fact table like this:

I then have a parameter named "url_base" which is something like:  "https://www.MYCOMPANY.com/PROGRAM/Tickets/Viewt.aspx?ID="

And I want to concatenate the date as a value yyyy/M/d and then concatenate the ticketreference

this is my attempt that is inefficient

URL =

Var Base_URL = "https://www.MYCOMPANY.com/PROGRAM/Tickets/Viewt.aspx?ID="
var Date= CONCATENATE(Base_URL,FORMAT(Ticket[Date], "yyyy/M/d"))
var TicketReference= CONCATENATE("*",Fact[TicketReference])
RETURN

CONCATENATE(Date,TicketReference)

Is there a better way to do this or do I need to create a calculated column?