Getting the latest Total value

[YingRui]

Hi, I would like to use DAX measurement to Display the Latest Total Value with reference to the time.

If I use Max, the value will only show 625, but i want it to display 600 as thats the latest updated value

Please help

[Nathaniel_C · Accepted solution]

Hi @YingRui ,

See below,
Let me know if you have any questions. I used a test in there so we didn't get zero.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

Latest time Total = 
var LateTime = CALCULATE(Max('Table'[Time]),'Table'[Completed]>0)
var LatestValue = CALCULATE(MAX('Table'[Total]),'Table'[Time]=LateTime)

return LatestValue

[YingRui]

Thankyou @Nathaniel_C

I changed the 'Table'[Completed] to 'Table[Total]

and i was able to achieve the total line when the last updated time was 9am

---

@Nathaniel_C wrote:

Hi @YingRui ,

See below,
Let me know if you have any questions. I used a test in there so we didn't get zero.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

Latest time Total = 
var LateTime = CALCULATE(Max('Table'[Time]),'Table'[Completed]>0)
var LatestValue = CALCULATE(MAX('Table'[Total]),'Table'[Time]=LateTime)

return LatestValue

---