topic how to get concatenate for 3 coloms in DAX Commands and Tips

how to get concatenate for 3 coloms

krishna_murthy — Sat, 22 Mar 2025 11:08:34 GMT

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

Re: how to get concatenate for 3 coloms

sanalytics — Sat, 22 Mar 2025 11:29:41 GMT

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

Re: how to get concatenate for 3 coloms

sanalytics — Sat, 22 Mar 2025 11:37:25 GMT

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

Re: how to get concatenate for 3 coloms

mdaatifraza5556 — Mon, 24 Mar 2025 05:09:12 GMT

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