How to Get value for last transaction?

Hi Anonymous 

If you want to have a calculated column, here are two ways:

Column = MAXX(TOPN(1,FILTER('Table','Table'[Transaction Time]<EARLIER('Table'[Transaction Time])),'Table'[Transaction Time],DESC),'Table'[Value])

Or

Column 2 = 
var __previousTranctionTime = MAXX(FILTER('Table','Table'[Transaction Time]<EARLIER('Table'[Transaction Time])),'Table'[Transaction Time])
return
MAXX(FILTER('Table','Table'[Transaction Time]=__previousTranctionTime),'Table'[Value])

And here is one way with measure

Last Value = 
var __previousTranctionTime = MAXX(FILTER(ALL('Table'),'Table'[Transaction Time]<SELECTEDVALUE('Table'[Transaction Time])),'Table'[Transaction Time])
return
SUMX(FILTER(ALL('Table'),'Table'[Transaction Time]=__previousTranctionTime),'Table'[Value])

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.