Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Card with percentage

Good afternoon,   I have a table with two columns, Year and percentage. Want to return the highest year's percentage on a card, any ideas?
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    Aha!

     

    I think this might be close.  Just change where I have Table2 to your tablename

     

    Measure = 
VAR maxYear = MAX('Table2'[Ano])
RETURN CALCULATE(
				MAX('Table2'[Reajustes]),
				FILTER(
					'Table2',
					'Table2'[Ano] = maxYear
					)
				)
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Here is the table I'm using.

 

The result I need is the 13.55% percentage for the year 2017.

 

This percentage will always be the most recent year.

 

 

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

what i suggested should work, just change the aggregation to Max for percentage