topic Concatenation Help in DAX Commands and Tips

Concatenation Help

Anonymous — Thu, 16 Apr 2020 19:59:13 GMT

I need to concatenate a measure and a column

Example for Volume I have quantity

To find total volume I do sum(quantity), but the unit of measurement is in different column which is a string.

How do I combine both the values

Say 100 KG --> 100 comes from sum(quantity) and KG is present in different column.

Thanks

Re: Concatenation Help

Greg_Deckler — Thu, 16 Apr 2020 21:59:40 GMT

New Column = [Measure] & " " & [Column]

Re: Concatenation Help

Anonymous — Fri, 17 Apr 2020 12:07:18 GMT

Hi Greg,

Really thanks for the prompt reply.

However I donot want a column, all I want is simple.

I have two colums, one quantity (numeric) and one UOM (text)

I want summation over quantity say sum(quantity) which gives me 100, now I need to put this value in chart and show the result as 100 KG...this KG comes from UOM column which is a string.

I would be obliged to connect with you, I work from India and support US hours. Let me know a way to connect to you.

Maybe whatsapp ? +91 8765045961

Best Regards

Re: Concatenation Help

Anonymous — Fri, 17 Apr 2020 12:36:50 GMT

[Volume] & " " & SELECTEDVALUE( T[ColumnWithUnit] )

But if this works... it means the design is flawed 🙂

Best

Re: Concatenation Help

Anonymous — Mon, 20 Apr 2020 15:02:51 GMT

Hi Greg,

Thanks for the help again. Unfortunately I am unable to put the filed in Value for a bar chart.

Regards

Anindya