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:

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

    If you decide to go with a NEW TABLE you'll need to add couple extra lines like this... for the Year and Month

     

    New Table =
SUMMARIZECOLUMNS (
    'SalesReport'[DATE].[Year],
    'SalesReport'[DATE].[Month],
    'SalesReport'[Name],
    'SalesReport'[ITEM],
    "Amount", MIN ( 'SalesReport'[Amount] ),
    "QTY", CALCULATE ( SUM ( SalesReport[ QTY] ) ),
    "Serial #", CONCATENATEX ( 'SalesReport', 'SalesReport'[Serial #] & " " ),
    "Total", MIN ( 'SalesReport'[Amount] ) * CALCULATE ( SUM ( 'SalesReport'[ QTY] ) )
)

    Here's this result...

     

    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.