Ultimo valor de la tabla

[tomybre]

Como hago para que en la pantalla negra me aparezca el ultimo valor de la tabla?

Saludos.

[CESGUT]

Saludos a todos,

Tengo un problema que puede ser sencillo pero no tengo mucha pericia en estas herramientas.

Estoy intentando calcular el ultimo valor de una tabla a la ultima fecha.

Necesito el valor encerrado en azul a la ultima fecha que tenga en la tabla

Saludos.

---

[Vvelarde]

@tomybre

Please be more specific about this.

Regards

Victor

[tomybre]

Victor, I have a table with date - currency - price . I want to have a measure that tells me which is the price of the last date on the table.

[Vvelarde · Accepted solution]

@tomybre

Hi you can use a measure:

PriceLastDate =
IF (
    HASONEVALUE ( Table1[Currency] );
    CALCULATE ( AVERAGE ( Table1[Price] ); LASTDATE ( Table1[Date] ) );
    UNICHAR ( 10 )
)

Select in the slicer the currency and Ready.

Regards

Victor

Lima - Peru

[tomybre]

Thank you very much for your answer but when I tried the measure, this appear:

How can I solve it?

[Vvelarde]

@tomybre

You need to close the Average Function. You are missing a ")"