CREATE NEW COLUM WITH TEXT + DATA FROM OTHER COLUMN

[qgturismo]

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:

NEW COLUMN = qg.tavo.la/pdf/arquivos/ + faturas[id] + .pdf

Where: qg.tavo.la/pdf/arquivos/ is a fixed text

Where: .pdf is a fixed text

Where: faturas[id] is a text from the column 'id' on my table

Should reply like this: qg.tavo.la/pdf/arquivos/58888.pdf

can anyone help me?

Regards

[Greg_Deckler · Accepted solution]

@qgturismo - If this is DAX then you would use:
NEW COLUMN = "qg.tavo.la/pdf/arquivos/" & faturas[id] & ".pdf"

[harshnathani]

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)

[qgturismo]

Hello @harshnathani 

Thank you very much. That's exactly what I need.

Regards