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

Vvelarde's avatar
Vvelarde
Community Champion
8 years ago

tomybre

 

Please be more specific about this.

 

Regards

 

Victor

 

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

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

        tomybre

         

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