how to get concatenate for 3 coloms

[krishna_murthy]

hi Team,

i have requirement here , Requesting please check and do the needful 

First Name	Last name	Sum of Age
East	pai	35
North	Kiran	30
Ramesh	Kumar	35
South	Yesh	40
West	Lol	56

i Want result is like ----

East Pai , 35

North Kiran ,30

Ramesh Kumar , 35

[sanalytics · Accepted solution]

@krishna_murthy 
Below is the DAX code as welll

DAX Code = 
SELECTCOLUMNS(
ADDCOLUMNS(
	Source,"@Col",
Source[First Name] & ","& Source[Last name] & ","& Source[Sum of Age]
),[@Col] )

screenshot

Let me know if you are looking for pbix file..

Hope it helps

Regards

sanalytics

[mdaatifraza5556 · Accepted solution]

Hi @krishna_murthy 

Follow the below steps to achieve it.

1. Step
        Go to Power Query ---> select Add Column ---> click Custom Column ----> Then write the query I wrote below.

Query 
-----------
[First Name] &" "& [Last name]&", "&Text.From([Sum of Age])

Result

[sanalytics]

@krishna_murthy 
Use below Power query code for your exact output

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45Wck0sLlHSUSpIzASSxqZKsTrRSn75RSUZQK53ZlFiHkjYACwclJibWgwWL81NLEIoD84vBSuPhMiaQFSHp4IN9snPAZKmZkqxsQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"First Name" = _t, #"Last name" = _t, #"Sum of Age" = _t]),
    TypeChanged = Table.TransformColumnTypes(Source,{{"Sum of Age", Int64.Type}}),
    Output =
Table.FromList(
Table.ToList(
    TypeChanged,each Text.Combine( List.Transform(_, each Text.From(_)),","
    )
),Splitter.SplitByNothing())
in
    Output

screenshot below

Let me know if you are ooking for DAX code or not.

Hope it helps

Regards,

sanalytics

[sanalytics · Accepted solution]

@krishna_murthy 
Below is the DAX code as welll

DAX Code = 
SELECTCOLUMNS(
ADDCOLUMNS(
	Source,"@Col",
Source[First Name] & ","& Source[Last name] & ","& Source[Sum of Age]
),[@Col] )

screenshot

Let me know if you are looking for pbix file..

Hope it helps

Regards

sanalytics