Forum Discussion

Elisa112's avatar
Elisa112
Icon for Helper V rankHelper V
1 year ago
Solved

Link customer ID to source system customer record

Hi Experts  Is it possible to link a customer ID from PBI to the source system record for that customer and if so how is this done? Our CRM is  off the shelf and not a microsoft product. Thanks i...
Need Help
  • johnt75's avatar
    johnt75
    1 year ago

    Create a new column

    Customer URL =
"domain.com/editcustomer.aspx?nActionId=2&strRef=" & 'Table'[CustomerID]
Elisa112's avatar
Elisa112
Icon for Helper V rankHelper V
1 year ago

The url looks like this

domain.com/editcustomer.aspx?nActionId=2&strRef=CustomerID, so I believe the link can be done.  I am not clear what dax is required, can you provide an example please?

many thanks 

johnt75's avatar
johnt75
Icon for Super User rankSuper User
1 year ago

Create a new column

Customer URL =
"domain.com/editcustomer.aspx?nActionId=2&strRef=" & 'Table'[CustomerID]
  • Elisa112's avatar
    Elisa112
    Icon for Helper V rankHelper V
    1 year ago

    Thank you, I watched a couple dynamic linking videos as well, had to adjust the URL slightly but all works perfectly.

    thank you for the guidance, much appreciated