Query Formula Help

[erhan_79]

Hi there ;

I have a  table with below columns on power bi 

Doc number	Material	Item No
567	MATA	10

i need to merge this 3 column as below , and want to create a new column whichs will be called " new code" 

New code

567MATA10

thnsk in advance for your supports 

[amitchandak]

@erhan_79 , Try as a new colum

new code = [Doc number]&[Material]&[Item No]

[erhan_79]

hi @amitchandak 

i tried but i got an error as below 

[Pragati11]

Hi @erhan_79 ,

You can create a calcukated column using DAX expression as follows:

new code = CONCATENATE([Doc number], CONCATENATE([Material], [Item No]))

you will get the required result.

Thanks,

Pragati

[erhan_79]

hi @Pragati11  ,

i tried your formula but i got an error as below 

[Pragati11 · Accepted solution]

Hi @erhan_79 ,

I think you didn't read my solution properly.

My solutions was purely based on DAX expression not query editor m-code.

In query editor try something like this:

new code = Number.ToText([Doc number]) & [Material] & Number.ToText([Item No])

Thanks,

Pragati

[erhan_79]

thank you @Pragati11  

now everything is ok 

thanks