Forum Discussion
Zyg_D
Continued Contributor
Continued ContributorCreate table containing only rows with minimum values from every category
Hello again. I tried to create a summarized table without some rows. This is the data table: I want to only show rows containing minimum values from specific category. This is the desire...
Zyg_D , you can create a table like
summarize(Table, Table[Category], "Value", min(Table[Value]), "Value2", max(Table[Value2]))
or can use a measure like this with Category in a visual min(Table[Value]) and max(Table[Value2])
amitchandak
Super User
Super UserZyg_D , you can create a table like
summarize(Table, Table[Category], "Value", min(Table[Value]), "Value2", max(Table[Value2]))
or can use a measure like this with Category in a visual min(Table[Value]) and max(Table[Value2])