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.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!