Forum Discussion
sromondas
3 years agoFrequent Visitor
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):
| Month | Country | Score |
| Jan | US | 5 |
| Feb | US | 6 |
| Jan | Canada | 7 |
| Feb | Canada | 9 |
| Jan | Germany | 4 |
| Feb | Germany | 1 |
I'm trying to calculate, in a new column, the minimum score for each country. So, the result should look something like this:
| Month | Country | Score | Country's Min Score |
| Jan | US | 5 | 5 |
| Feb | US | 6 | 5 |
| Jan | Canada | 7 | 7 |
| Feb | Canada | 9 | 7 |
| Jan | Germany | 4 | 1 |
| Feb | Germany | 1 | 1 |
Many thanks
Hi sromondas
CALCULATE ( MIN ( 'Table'[Score] ), ALLEXCEPT ( 'Table', 'Table'[Month], 'Table'[Country] ) )