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.

 

 

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
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

    Thank you for your help. Worked perfectly.