How to combine Coy and Ref and Date into one field ?

[Anonymous]

Hi All

I have below raw data :-

Company,Ref,Date

SCM Technology Pte Ltd,0001,23/12/2019

ADL Pte Ltd,0002,23/11/2019

Expected Result :-

Co_Ref_Date

0001 SCM Tec 23/12/2019

0001 ADL Pte 23/12/2019

My purpose is combine 3 feild info to one field , For company i pick the frist 6 charater , Hope some one can help me.

Paul

[Anonymous · Accepted solution]

@Anonymous 
You need to modify the measure based on your table/Column name..could see that your table name is different than used in measure .
Please use the below Measure 
Concatenate= [Ref] & left([Company],6) & [Date]

[Anonymous]

@Anonymous  : You Can use Below Formula to create new Column .

New Column = Combinevalue(" - ",'Tbl1 (2)'[Ref] , LEFT('Tbl1 (2)'[Company],7) ,Tbl1 (2)'[Date] )

Always use Combinevalue to concat multiple column . It is more efficiant than other method. 

Give Me Kudos If Find it More Suitable .

[Anonymous]

Hi Sir

I still get error :-

[Anonymous · Accepted solution]

@Anonymous 
You need to modify the measure based on your table/Column name..could see that your table name is different than used in measure .
Please use the below Measure 
Concatenate= [Ref] & left([Company],6) & [Date]

[Anonymous]

New Column = Combinevalues(" - ", 'Tbl1 (2)'[Ref] , LEFT('Tbl1 (2)'[Company],7) ,Tbl1 (2)'[Date])

Correct Formula

[Anonymous]

Hi Sir

I get error msg :-

The following syntax error occurred during parsing: Invalid token, Line 1, Offset 75, '[Date] )).

Paul

[Tahreem24]

@Anonymous ,

Use the below Column:

Combine Column = 'Tbl1 (2)'[Ref] &" " & LEFT('Tbl1 (2)'[Company],7) & " " &'Tbl1 (2)'[Date]

Find the screen shot of your answer:

[amitchandak]

@Anonymous , Try a new column like

new column
= [Ref] & left([Company],6) & [DAte]

[Anonymous]

Hi All 

Thank you very much for every one help , i manage to create my first expression  , meaning i cannot copy and paste the script . need manually typing the expression word by word.

[Anonymous · Accepted solution]

@Anonymous  You can copy measure from any website and add to Power bi ...you need to click on formula bar first and then CTRL+V

[Anonymous]

Hi Sir

Thank you very much for your info , good is it will save a lot of my time , bad is that i will not rememeber the syntax. 

Paul Yeo