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