Grouping and unique values

hello UDMH 

please check if this accomodate your need.

create new table with following DAX.

Summarize =
SUMMARIZE(
    FILTER(
        'Table',
        'Table'[Description]<>BLANK()&&
        'Table'[Text]<>BLANK()
    ),
    'Table'[Code],
    'Table'[Name],
    'Table'[Description],
    'Table'[Text],
    "Amount",
    CALCULATE(SUM('Table'[Amount]),ALLEXCEPT('Table','Table'[Code]))
)

 

 

Hope this will help.

Thank you.

Hi,

One of ways to create a new table is writing DAX formula something like below.

Please check the below picture and the attached pbix file.

expected result table = 
	SUMMARIZECOLUMNS(
		Data[Code],
		Data[Name],
		Data[Description],
		Data[Text],
		FILTER(
			Data,
			Data[Name] <> BLANK() && Data[Description] <> BLANK() && Data[Text] <> BLANK()
		),
		"@Amount", CALCULATE(
			SUM(Data[Amount]),
			ALLEXCEPT(
				Data,
				Data[Code]
			)
		)
	)

Hi UDMH ,
You could try the below simple version using Dax:

NewTable = 
SUMMARIZE(
    'Table',
    'Table'[Code],
    "Name", MAX('Table'[Name]),
    "Description", MAX('Table'[Description]),
    "Text", MAX('Table'[Text]),
    "Amount", SUM('Table'[Amount])
)

Also, you could use power query group by transformation. See images below:

Hope this helps!!

If this solved your problem, please accept it as a solution!!

Best Regards,

Shahariar Hafiz