Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
You can just add & "/view" on the end.
URL = "https://salesforce.com/" & '!My_Report'[Case Number] & "/view"
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
You can just add & "/view" on the end.
URL = "https://salesforce.com/" & '!My_Report'[Case Number] & "/view"
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
thanks Pat, knew it was simple!
You can use the concatinate function; https://docs.microsoft.com/en-us/dax/concatenate-function-dax
thanks but isnt that just contatinating columns, /view isn't in a column
User | Count |
---|---|
42 | |
26 | |
21 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |