cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
frenchiedc87
Helper I
Helper I

How to combine URL and text

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

1 ACCEPTED SOLUTION
Pragati11
Super User III
Super User III

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





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




View solution in original post

3 REPLIES 3
Pragati11
Super User III
Super User III

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





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




View solution in original post

Thanks

Mariusz
Super User II
Super User II

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

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.