Merge Rows using DAX

Question

Hello,&nbsp;&nbsp;I'm wondering if someone can help in what I percieve to be a simple query,&nbsp;I have a table which I have created in DAX using SELECT COLUMNS and CALCULATETABLE.&nbsp;&nbsp;&nbsp;The result of thisis the following table:&nbsp;As you can probably see in this table all rows share the same [Contract] in column 1, I would like this to all appear in one row rather than 3 rows. usually I would do this in power query and unpivot etc. but as this is a calculated table is there a way to do this in DAX?&nbsp;&nbsp;As always any help or ideas are always appricated.&nbsp;Dobby Libr3

amitchandak · Accepted Answer

First GIndex has different values in all three columns.Second, there should be aggregation function to group&nbsp; function like Min, Max on all other columns&nbsp;You can also try summarize. example&nbsp;SUMMARIZE(
                data,
                data[ID],
				"max_date",
				MAX( 'Date'[Date]),
                "Max_Col", max(data[Col1])
            )Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @ Thanks. My Recent Blog -https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739 https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601&nbsp;&nbsp;

Forum Discussion

Merge Rows using DAX

2 Replies

Related content

Merge 2 Rows

Merge row cells

Merge 2 rows in one row

SCD Type 2 Using MERGE in delta

Merging 2 rows