Forum Discussion

karinab18's avatar
karinab18
New Member
9 years ago
Solved

add concatenated column to summarize table

HI, I am trying to biuld a table for reporting out summarized data used by finance.  My data samples are below along with the current SUMMARIZE function I am using.  The part I am stuck on is concate...
  • Sean's avatar
    Sean
    9 years ago

    You don't really new a New Table - you can do this in a Matrix with 1 MEASURE

     

    Serials MEASURE =
IF (
    HASONEVALUE ( SalesReport[ITEM] ),
    CONCATENATEX (
        SalesReport,
        SalesReport[Serial #],
        " ",
        SalesReport[Serial #], ASC
    )
)

    Here's the result :smileyhappy:

     

    Hope this helps! :smileyhappy:

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago

You don't really new a New Table - you can do this in a Matrix with 1 MEASURE

 

Serials MEASURE =
IF (
    HASONEVALUE ( SalesReport[ITEM] ),
    CONCATENATEX (
        SalesReport,
        SalesReport[Serial #],
        " ",
        SalesReport[Serial #], ASC
    )
)

Here's the result :smileyhappy:

 

Hope this helps! :smileyhappy:

karinab18's avatar
karinab18
New Member
9 years ago

Thank you, I added the measure to my table and was able to summarize the data correctly.  Really appreciate the help here.