Aggregation per row in table

Hi patricia1707 ,

 

Based on the information you provided, you can follow these steps below:

 

1.Add Index Column From 1 in Power Query

 

 

 

2.Add a Column

 

ID =

VAR _1 =

    RANKX (

        FILTER ( ALL ( 'Table' ), 'Table'[kpi_id] = EARLIER ( 'Table'[kpi_id] ) ),

        'Table'[Index],

        ,

        ASC

    )

RETURN

    IF ( _1 = 1, 'Table'[kpi_id], BLANK () )

 

 

Final output:

 

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

 

^{Best Regards,}

^{Yifan Wang}

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