Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Concatenate help

Hi,   I am new to Power BI, but making progress, however I have a problem that I can't figure out.   I have  created a Table Visualization with a text column called "Opportunity ID2", and some ot...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Thanks for the replies - I did say I was new to this!

     

    It was the syntax of the TableName that was catching me out i tried the SELECTEDVALUE approach, but that just gave me the URL and not the other column, but it did show me how to get the field name in the expression,

     

    I have solved it now by adding brackets and single quotes to the table name like this:

     

    Link to Opp = "https://xxxxxxxx.my.salesforce.com/" & ('Current Quarter'[Opportunity ID2])

     

    an dthis now works for me. Thanks

     

    Andrew

     

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks for the replies - I did say I was new to this!

 

It was the syntax of the TableName that was catching me out i tried the SELECTEDVALUE approach, but that just gave me the URL and not the other column, but it did show me how to get the field name in the expression,

 

I have solved it now by adding brackets and single quotes to the table name like this:

 

Link to Opp = "https://xxxxxxxx.my.salesforce.com/" & ('Current Quarter'[Opportunity ID2])

 

an dthis now works for me. Thanks

 

Andrew

 

 

robofski's avatar
robofski
Resolver II
8 years ago

Glad you got it sorted, and don't apologise for being new to it, we were all new once!

 

The intellisense in Power BI is usually really good at taking care of all that stuff for you, I always start typing the field I want and then select it from the offered list so it populates correctly with the table name etc automatically using quotes where required (I think only if there is a space in the table name are single quotes required).