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 NameRankingYear
India122019
India102020
US22020
US12019

 

Please help me to achieve this.

 

Thanks

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.

2 Replies

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    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 )