Combine data into a single field

Hi janaselva,

Here's a solution:

Create a new table Table B, with rhe following formula:

Table B =
Summarize('Table A',
'Table A'[Contract No],
"Consolidated_Invoice_Amount",SUM('Table A'[Invoice amount]),
"Invoice_number",CONCATENATEX('Table A','Table A'[Invoice no],","),
"Invoice_date",CONCATENATEX('Table A','Table A'[Invoice_Date],",")
)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Manguilibe KAO