How to Get value for last transaction?

[Ibrahimxix]

Hi guys

I have a table with value and inventory I want to multiply the value into inventory based on the last transaction that happened to this stock

"more clarification"

Inventory * Value (in the last inventory transaction)

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.  Clearly show where you want to generate the result.

[Ibrahimxix]

thank you brother 

[v-jingzhang · Accepted solution]

Hi @Ibrahimxix 

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.

[Ibrahimxix]

Thank you very much, I got the result🌹

[parry2k]

@Ibrahimxix you can use LASTNONBLANKVALUE DAX measure to get the value

Last Value = 
LASTNONBLANKVALUE ( CalendarTable[Date], SUM ( YourTable[Value] ) )

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Ibrahimxix]

 same result