Forum Discussion

pbidemouser2's avatar
pbidemouser2
Icon for Helper II rankHelper II
6 years ago
Solved

How to show only the latest data for each timestamp

 Hi all,   I am working with a live data connection which gets data in a hourly basis. I am facing difficulties in using DAX. I have a dataset similar to the one below. Timestamp      Value 15/06...
Need Help
Tips and Tricks
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi pbidemouser2 ,

     

    This is very strange.

    Are you saying that you can‘t use the [Timestamp] column in the LASTNONBLANKVALUE() function?

    What error did you encounter?

    Please send a screenshot of your error message.

     

    Or try this measure formula.

    Measure 3 = 
CALCULATE(
    MAX(Sheet4[Value]),
    ALLEXCEPT(Sheet4, Sheet4[Timestamp] )
)

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

pbidemouser2 , Try if this can help

LASTNONBLANKVALUE(Table[timestamp],sum(table[Value]))

    • v-lionel-msft's avatar
      v-lionel-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi pbidemouser2 ,

       

      Please refer to the below formula.

      Measure 2 = 
LASTNONBLANKVALUE(
// the name of my table is 'Sheet4'
    Sheet4[Timestamp],
    MAX( Sheet4[Value] )
)

       

      Best regards,
      Lionel Chen

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

       

      • pbidemouser2's avatar
        pbidemouser2
        Icon for Helper II rankHelper II
        6 years ago

        HI v-lionel-msft ,

        I tried the measure u told. The Sheet4[Timestamp] part doesnt work. 

         
         

        Since the Timestamp column isnt a measure here, i couldnt use it in this. Could you pls suggest me what to do?

         

        Thanks