topic Re: Custom WEB URL in DAX Commands and Tips

Custom WEB URL

CMC — Thu, 11 Mar 2021 00:08:23 GMT

I have a current measure which has been working well and directs me to a customer URL based on case number raised. e.g.

URL = "https://salesforce.com/" & '!My_Report'[Case Number] - https://salesforce.com.com/Case/XXXXXXXXX

Now I noticed the backend URL has changed to https://salesforce.com.com/r/Case/XXXXXXXXX/view

How can I amend /view onto the end of the URL after the Case Number has been injected?

Re: Custom WEB URL

Robbief — Thu, 11 Mar 2021 00:28:42 GMT

You can use the concatinate function; https://docs.microsoft.com/en-us/dax/concatenate-function-dax

Re: Custom WEB URL

CMC — Thu, 11 Mar 2021 00:56:05 GMT

thanks but isnt that just contatinating columns, /view isn't in a column

Re: Custom WEB URL

mahoneypat — Thu, 11 Mar 2021 01:16:27 GMT

You can just add & "/view" on the end.

URL = "https://salesforce.com/" & '!My_Report'[Case Number] & "/view"

Regards,

Pat

Re: Custom WEB URL

CMC — Thu, 11 Mar 2021 01:17:59 GMT

thanks Pat, knew it was simple!

Re: Custom WEB URL

saiprathapdp — Sat, 03 Jul 2021 16:57:33 GMT

Hi pat,

can you please help us to resolve below requirment.

Ex: we want to create URL only for Dev,Prod,QA (we followed above Measure which you have shared it is working fine but we are getting URL for Sandbox as well but we don't want that)

We are getting like below but we want to create URL only for Devlopment,Quality,Production because we don't have any URL for Sandbox

Type WorkON ID URL

Sandbox Sandbox https://myworld.com/Sandbox

Devopment Cloud-19 https://myworld.com/Cloud-19

Production Cloud-21 https://myworld.com/Cloud-21

Quality Cloud-2 https://myworld.com/Cloud-2

Sandox Sandbox https://myworld.com/Sandbox

Quality Cloud-1 https://myworld.com/Cloud-1

Devlopment Cloud-420 https://myworld.com/Cloud-420