Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

need a measure

Hi,   I needed two measures to know current year ranking and previous year ranking from the data below:   Country Name Ranking Year India 12 2019 India 10 2020 US 2 2020 US...
Need Help
  • vanessafvg's avatar
    vanessafvg
    6 years ago
    CurrentYearRank = CALCULATE(sum(Countries[Ranking]), FILTER(Countries, Countries[Year] = year(today())))
    PreviousYearRank = CALCULATE(sum(Countries[Ranking]), FILTER(Countries, Countries[Year] = year(today())-1))
     
    This should work.
az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

try

CurrentYear = CALCULATE(MAX(Table[Ranking]), Table[Year] = YEAR(TODAY()) )

and

PrevYear = CALCULATE(MAX(Table[Ranking]), Table[Year] = YEAR(TODAY())-1 )