Bring the Min value in a column

AllanArayita — Wed, 03 Jul 2024 21:56:21 GMT

Hello Good People!

Can you help to figure out how to create the Min Value in a column - taking the small value of a data?

Example: In Soccer Value: 2 - In Baseball Value: (repeated in all rows the last Value)

Sport	Value
Socccer	2
Socccer	3
Socccer	4
Socccer	4
Baseball	4
Baseball	4
Baseball	1
Baseball	3
Baseball	6

Re: Bring the Min value in a column

Anonymous — Thu, 04 Jul 2024 01:55:18 GMT

Hi AllanArayita ,

The Table data is shown below:

Please follow these steps:

1.Add an index column after grouping by column 'Sport' in Power query.

Table.AddIndexColumn([Count],"Index",1)

2.Use the following DAX expression to create a column

Column = SWITCH(TRUE(), [Sport] = "Socccer", CALCULATE(MIN('Table'[Value]),ALLEXCEPT('Table','Table'[Sport])), [Sport] = "Baseball", VAR _maxIndex = CALCULATE(MAX('Table'[Index]),ALLEXCEPT('Table','Table'[Sport])) RETURN CALCULATE(MAXX(FILTER('Table',[Index] = _maxIndex),[Value]),ALLEXCEPT('Table','Table'[Sport])) )

3.Final output

Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Bring the Min value in a column in DAX Commands and Tips

Bring the Min value in a column

Re: Bring the Min value in a column