Forum Discussion
Solved
Create table containing rows with smallest values from every category
This must be very easy, but I don't remember at the moment. The goal is to create a new table based on Table1:
Only the rows containing the smallest Value of every Category should go to the new table. Resulting in this:
What formula can I use?
Zyg_D , you can create a new table like
summarize(Table, Table[Category], Table[Info], "Value", min(Table[Value]))
or use measure min(Table[Value]) with Category and Info in table or matrix visual
1 Reply
Zyg_D , you can create a new table like
summarize(Table, Table[Category], Table[Info], "Value", min(Table[Value]))
or use measure min(Table[Value]) with Category and Info in table or matrix visual