Custom WEB URL

[CMC]

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?

[mahoneypat · Accepted solution]

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

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

Regards,

Pat

[saiprathapdp]

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

[CMC]

thanks Pat, knew it was simple!

[Robbief]

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

[CMC]

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