Forum Discussion

AndreiFlorian's avatar
AndreiFlorian
Frequent Visitor
6 years ago
Solved

Find Latest Value from Array

Hi there, I am aware that there are other threads to do with this issue and I have looked over them though I did not manage to make the project work. I have an array called batteryVoltage which stor...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    Hmm, I am guessing that the last row of data doesn't have a reading.  Can you try changing the mesure to this?

    Last Battery =
VAR _MaxTime =
    CALCULATE (
        MAX ( 'SensoEvents'[TimeStamp] ),
        KEEPFILTERS ( ALL ( 'SensoEvents'[TimeStamp] ) )
    )
RETURN
    CALCULATE ( SUM ( 'SensoEvent'[Battery] ), 'SensoEvents'[TimeStamp] = _MaxTime )

    See if keeping the other filters lets us get a result.

AndreiFlorian's avatar
AndreiFlorian
Frequent Visitor
6 years ago

Hi,

I do have a timestamp attached to the data, I have an example of the table below.

 

Timestampbattery
06/10/2019 20:42:060
06/10/2019 20:42:060
06/10/2019 20:42:060
06/10/2019 20:42:063.3
06/10/2019 20:42:063.3
06/10/2019 20:42:063.2
06/10/2019 20:42:063.1

 

Ultimately, I need to return the last value (3.1).

Andrei

jdbuchanan71's avatar
jdbuchanan71
Super User
6 years ago

All of those times are the same (20:42:06) but assuming they are not that way in your data it will be something like so:

Last Battery = 
VAR _MaxTime = 
CALCULATE(
    MAX ( 'Table'[Timestamp] ),
    ALL ( 'Table'[Timestamp] )
)
RETURN
CALCULATE(
    SUM ( 'Table'[battery] ),
    'Table'[Timestamp] = _MaxTime
)

  • AndreiFlorian's avatar
    AndreiFlorian
    Frequent Visitor
    6 years ago

    Hi, I tried the code provided but I get the following errors when hovering over the table names:

     

    Parameter is not the correct type

    Cannot find name '[Timestamp]'

     

    Andrei.

    • jdbuchanan71's avatar
      jdbuchanan71
      Super User
      6 years ago

      Is the field called something else in your model or is it not a date/time field?

      • AndreiFlorian's avatar
        AndreiFlorian
        Frequent Visitor
        6 years ago

        The field names are correct, I am not sure if the timestamp field is classified as a time field. It seems to be the same as the battery field. Is there a way to declare it as a date/time field?

        Andrei