Forum Discussion

New Member

8 years ago

Solved

Ultimo valor de la tabla

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

8 years ago

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

Community Champion

8 years ago

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

New Member

8 years ago

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

How can I solve it?

Vvelarde
Community Champion
8 years ago
tomybre

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

Related content