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.

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

    • v-lionel-msft's avatar
      v-lionel-msft
      Icon for Community Support rankCommunity Support
      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.