Forum Discussion

Zyg_D's avatar
Zyg_D
Continued Contributor
6 years ago
Solved

Create 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...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    6 years ago

    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's avatar
amitchandak
Super User
6 years ago

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])