any one please suggest the formula to filter the first id iof Each group after applying the Group by.
Id , Value
Filter Table Should be:
Please proivide any solution to achieve this.
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)))
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.
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.
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.
We are excited to announce that Demo Extravaganza for 2021 has started!