Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Concatenation Help

Hi   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....
Comcatenation
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    [Volume] & " " & SELECTEDVALUE( T[ColumnWithUnit] )

     

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

     

    Best

    D

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Greg,

       

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

       

      Regards

      Anindya