show last value of a column

[raykhey]

Hello, i want to show on a card the last value (from timestamp) of my progression , i tried LASTNONBLANK('Project'[data.progress],1) but it returns 0.88 which is not the last value (0.83)

thanks

[Anonymous · Accepted solution]

Hi @raykhey ,

The following DAX might work for you:

lastdata =

VAR Lasttimestamp = CALCULATE(LASTDATE('project'[timestamp]),ALLSELECTED(project))

RETURN

CALCULATE(SUM(project[data.progress]),project[timestamp]=Lasttimestamp)

The final output is shown in the following figure:

Best Regards,

Dino Tao

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

[JTBusinessIntel]

Hey Raykhey,

If you don't need to know the value of the preceding dates (Where the .88 is occurring) the following DAX might work for you. 

Last Value Progress = 
var max_date = MAX('Table'[timestamp])
var return_value = Calculate(MAXX(TOPN(1,'Table'),'Table[data.progress]), 'Table'[timestamp] = max_date)

return
return_value

I'm not sure what your table looks like but that should do the trick for pulling the last value from the table.

Let me know if that works or you have any questions!

Best,

JTB