how to Filter the first id each Group after applying Group by

[Anonymous]

Hi all,

any one please suggest the formula to filter the  first id iof Each group after applying the Group by.

Source Table:

Id   ,  Value

101,AST

106,AST

114,AST

126,Bottle

129,Bottle,

130,Nike,

142,Nike

Filter Table Should be:

101,AST

126,Bottle

130,Nike

Please proivide any solution to achieve this.

[Mike8]

Hello,

I think that it can be improved but the following expression can solve your issue..
Gallery1.Items = ForAll(Distinct(A,Value),LookUp(A,Id=Min(Filter(A,Value=Result),Id)))

[Meneghino]

Here is a suggestion that only requires reading the source table once:

AddColumns(
    GroupBy(
        SourceTable,
        "Value",
        "AllRows"
        ),
    "MinId",
    Min(AllRows, Id)
    )

 The result will contain the AllRows column, but this can be ignored.

[Mike8]

I think Meneghino's solution is better. You should use that one.
You can use the DropColumns() function to get rid of the AllRows column if you want to.