Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello All
I'd like to create a new column with a text which I wrote and part of this text will be filled with a data from another column. In the end, this text will be a web site URL.
Something Like this:
Solved! Go to Solution.
@qgturismo - If this is DAX then you would use:
NEW COLUMN = "qg.tavo.la/pdf/arquivos/" & faturas[id] & ".pdf"
@qgturismo - If this is DAX then you would use:
NEW COLUMN = "qg.tavo.la/pdf/arquivos/" & faturas[id] & ".pdf"
Hi @qgturismo ,
Assuming id is a number value.
NEW COLUMN = CONCATENATE( CONCATENATE( "qg.tavo.la/pdf/arquivos/",VALUE(faturas[id] )) , ".pdf")
Incase Id is a text value.
NEW COLUMN = CONCATENATE( CONCATENATE( "qg.tavo.la/pdf/arquivos/",faturas[id] ) , ".pdf")
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
84 | |
83 | |
72 | |
49 |
User | Count |
---|---|
143 | |
130 | |
108 | |
64 | |
55 |