Combine Rows and show in a Table

Anonymous

Not applicable

1 year ago

Thanks for the reply from amitchandak , please allow me to provide another insight:

Hi, gssarathkumar

We currently have two solutions, each with its own drawbacks. You can choose based on your needs:

1.Firstly, you can merge the two tables and create an index, keeping only the first one:

First, create an index column in Power Query:

let
    Source = Table.NestedJoin(Table, {"Engagement"}, #"Table (2)", {"Engagement"}, "Table (2)", JoinKind.RightOuter),
    #"Expanded Table (2)" = Table.ExpandTableColumn(Source, "Table (2)", {"Topic", "Owner", "Implications", "Action Required", "Timing"}, {"Table (2).Topic", "Table (2).Owner", "Table (2).Implications", "Table (2).Action Required", "Table (2).Timing"}),
    #"Grouped Rows" = Table.Group(#"Expanded Table (2)", {"Engagement"}, {{"Count", each Table.AddIndexColumn(_, "Index", 1, 1, Int64.Type)}}),
    #"Expanded Count" = Table.ExpandTableColumn(#"Grouped Rows", "Count", {"SLA & Obligation Remarks", "Stability & Availability Remarks", "Security & Vulnerability Remarks", "Customer Sentiment", "Table (2).Topic", "Table (2).Owner", "Table (2).Implications", "Table (2).Action Required", "Table (2).Timing", "Index"}, {"Count.SLA & Obligation Remarks", "Count.Stability & Availability Remarks", "Count.Security & Vulnerability Remarks", "Count.Customer Sentiment", "Count.Table (2).Topic", "Count.Table (2).Owner", "Count.Table (2).Implications", "Count.Table (2).Action Required", "Count.Table (2).Timing", "Count.Index"})
in
    #"Expanded Count"

Next, use the following calculated column:

engagement1 = 
VAR FIRST=CALCULATE(MIN('Merge1'[Count.Index]),ALLEXCEPT('Merge1','Merge1'[Engagement]))
RETURN IF('Merge1'[Count.Index]=FIRST,'Merge1'[Engagement],BLANK())

There is a link to a similar issue:

https://community.fabric.microsoft.com/t5/Desktop/Group-by-ID-Skip-Aggregation/td-p/3976285

Here's my final result, which I hope meets your requirements.