Forum Discussion

sromondas's avatar
sromondas
Frequent Visitor
3 years ago
Solved

Help with calculating minimum value

Hello,

i have my data structured in the following manner (this is just a simplified version of what my table looks like):

MonthCountryScore
JanUS5
FebUS6
JanCanada7
FebCanada9
JanGermany4
FebGermany1

 

I'm trying to calculate, in a new column, the minimum score for each country. So, the result should look something like this:

MonthCountryScoreCountry's Min Score
JanUS55
FebUS65
JanCanada77
FebCanada97
JanGermany41
FebGermany11

 

Many thanks

  • Hi sromondas 

    CALCULATE ( MIN ( 'Table'[Score] ), ALLEXCEPT ( 'Table', 'Table'[Month], 'Table'[Country] ) )

2 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion

    Hi sromondas 

    CALCULATE ( MIN ( 'Table'[Score] ), ALLEXCEPT ( 'Table', 'Table'[Month], 'Table'[Country] ) )