topic Re: How to get as per the latest datetime ? in DAX Commands and Tips

How to get as per the latest datetime ?

mohittimpus — Thu, 29 Apr 2021 13:32:59 GMT

Hello,

I'm trying to get a value from table which has a recent datetime.

I'm trying this logic but its not working :

CALCULATE (
AVERAGE ( table[values] ),
FILTER ( ALL ( table ), table[DateTime] >= MAX ( table[DateTime] ) )
)

Thank you.

amitchandak — Thu, 29 Apr 2021 13:47:44 GMT

measure =
var _max = Maxx( ALL ( table ), table[DateTime] ) //OR //Maxx( ALLSelected ( table ), table[DateTime] )

return
CALCULATE (
AVERAGE ( table[values] ),
FILTER ( ALL ( table ), table[DateTime] =_max )
)

Jihwan_Kim — Thu, 29 Apr 2021 13:53:08 GMT

Please correct me if I wrongly understood your question.

Please check the below picture and the measure, whether it is what you are looking for.

Last sales total =

LASTNONBLANKVALUE( 'Table'[Date], [Sales total])

The link is down below.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

CNENFRNL — Thu, 29 Apr 2021 23:48:16 GMT

Measure = VAR __time = MAX( table[DateTime] ) RETURN CALCULATE( AVERAGE( table[values] ), table[DateTime] >= __time )