Solved: first n values in

PARAG_26 · ‎10-09-2023

BRCODECIF

In the above list i want dynamically to select first two cell from each distinct value in brcode like

brcode cif

1221 1

1221 5

518 2

518 7.

I tried List.FirstN after grouping but it is giving error. Please hep

wdx223_Daniel · ‎10-09-2023

NewStep=Table.Combine(Table.Group(PreviousStepName,"BRCODE",{"n",each Table.FirstN(_,2)})[n])

PARAG_26 · ‎10-10-2023

Hi Daniel... it worked. Many thanks for your accurate and prompt reply

wdx223_Daniel · ‎10-09-2023

NewStep=Table.Combine(Table.Group(PreviousStepName,"BRCODE",{"n",each Table.FirstN(_,2)})[n])

first n values in