I am not able to get the Value from a column based on maximum date from another column

[sathishsam]

Hi Experts,

Here is my simple model. I am trying to get the Latest Temperature from the below table (This is a live stream data)

Latest Temp =

var dt = CALCULATE(LASTDATE(RealTimeData[Date]), ALLSELECTED(RealTimeData))

RETURN

CALCULATE(SUM(RealTimeData[Temperature]), RealTimeData[Date] = dt)

Not sure why Latest Temp returns blank 😞

[sathishsam · Accepted solution]

I solved it by adding a DateKey column

DateKey = YEAR(RealTimeData[Date])&Month(RealTimeData[Date])&Day(RealTimeData[Date])

Latest Temp =

Var Result= CALCULATE(SUM(RealTimeData[Temperature]),

    RealTimeData[DateKey] = MAX(RealTimeData[DateKey]))

RETURN

Result

[Uzi2019]

Hi @sathishsam 
Try this 

Measure= 
Var Max_date= Max( 'Table'[Date])
Var Result= Calculate ( Sum( 'RealTimeData'[Temperature]), Filter ( ALL(RealTimeData), [Date]= Max_date))

I hope this may resolve your query.

I hope I answered your question!

[sathishsam]

It didn't work

[Rupak_bi]

Hi @sathishsam 

Your date have timestamp as well. Instead of LASTDATE, Try using MAX(table,date). This should work.

[sathishsam]

MAX didn't work

[Rupak_bi]

Hi @sathishsam ,

Please ensure there is no other filter or slicer in the dashboard. Max should work.
alternate way....

I also can see, you already have a measure "maxDt". you can refer that as well.

Latest Temp =calculate(SUM(RealTimeData[Temperature]),allexcept(RealTimeData,RealTimeData[City]), RealTimeData[Date] =[maxDt])

[Mahesh0016]

@sathishsam please try the below DAX.

Latest Temp =

VAR dt = CALCULATE(
                                        MAX( RealTimeData[Date] )
                                      , ALLSELECTED(  RealTimeData[City], RealTimeData[Date]  )
                            )

VAR  Temperatures = SUM(RealTimeData[Temperature])

RETURN

CALCULATE(
                      Temperatures
                      , RealTimeData[Date] = dt
                 )

@sathishsam i hope this helps you. Thank You!

[sathishsam]

Thanks Mahesh, this is returning me 226.20 (Total Temperature). I am expecting 22.8

[Mahesh0016]

@Rupak_bi 
ohk, do you want to city wise latest Temperature...?

please brief me on it. Thank You!

[sathishsam]

yes, at present i have data only for one city (Bangalore)