Forum Discussion

tomybre's avatar
tomybre
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.

Need Help
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    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

6 Replies

    • tomybre's avatar
      tomybre
      New Member
      8 years ago

      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's avatar
        Vvelarde
        Community Champion
        8 years ago

        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

  • CESGUT's avatar
    CESGUT
    Regular Visitor
    7 years ago

    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.