How to combine URL and text

[frenchiedc87]

Bonjour

I am trying to combine this URL https://www.xxx.com/ which is not part of my fields and "contract key" which is part of the fields available in my data set.

Any idea about a solution

Thanks

A

[Pragati11 · Accepted solution]

HI @frenchiedc87 ,

You can use CONCATENATE finction in Power BI to achieve this.

Something as below:

combinedValue = CONCATENATE("https://www.xxx.com/", Table1[COLUMN])

Replace Table1[COLUMN] in above dax with your contract key column.

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[frenchiedc87]

Thanks

[Mariusz]

Hi @frenchiedc87 

you can add an extra column to your table that concatenates URL and Key and create a function that will call this URL and return the data.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn