i need to create a new column which should be a combination as below:
Column1 = https://microsoft.visualstudio.com/xxxx/xxx/xxx/1234567
Column1 = "Text"+ABC where ABC is an existing column with value as 1234567 and "text" is supplied value as above mentioned.
Please help on it.
Go to Solution.
Use the below shown concatenate to create a column also shown below.
NewColumn = CONCATENATE("https://microsoft.visualstudio.com/xxxxx/xxxx",Table2[Column2])
If this helped you, please mark this post as an accepted solution and like to give KUDOS .
Are you also having the "Text" and ABC both available in separate columns?
ABC is available in a column and i am supplying Text (Text does not available in any column)
Thank you very much.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
Register by September 5 to save $200
Check out what's new in the Power BI Community!
Continue your learning in our online communities.