Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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)
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.