Forum Discussion

love's avatar
love
Icon for Helper I rankHelper I
8 years ago
Solved

How to return min value for different groups of data

Hello.   I am working with a set of data simliar to this:   TASK CONFIG ID EXPECTED OUTPUT Task A Config A 1 1 Task A Config A 2 1 Task A Config A 3 1 Task A Config B 4 4 Task A ...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    HI love

     

    Try this

     

    Column =
CALCULATE (
    MIN ( TableName[ID] ),
    ALLEXCEPT ( TableName, TableName[TASK], TableName[CONFIG] )
)
love's avatar
love
Icon for Helper I rankHelper I
8 years ago

/friendly push :cathappy:

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

HI love

 

Try this

 

Column =
CALCULATE (
    MIN ( TableName[ID] ),
    ALLEXCEPT ( TableName, TableName[TASK], TableName[CONFIG] )
)
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    8 years ago

    love

     

    Using Power Query / Query  Editor

     

    Go to Transform Tab>>>Group By>>Advanced

     

    See the pic below

     

    • love's avatar
      love
      Icon for Helper I rankHelper I
      8 years ago

      Hi Zubair_Muhammad

       

      Both of your suggested solutions perfectly meet the requirements in my OP, thank you very much for the uncomplicated and elegand suggestions! 

       

      I ended up going for the DAX solution because if I use the "Group by" solution in the query editor the grouping actually removes all lines that do not have the MIN(ID) which is not what I want but I see that I did not make that very clear in my OP.

       

      Thanks again! :smileyhappy: