Hello I am trying to get a card to display our most recent stock on hand. I want it to refresh when new items are added to dataset. So far its only summing and averaging all items.
@RJPostguard you can use INDEX function to get the latest data:
Latest Stock Measure =
CALCULATE (
SUM ( Table[Stock] ),
INDEX (
1,
ALLSELECTED ( Table ),
ORDERBY ( Table[Date], DESC ),
PARTITIONBY ( Table[Item] )
)
)Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@RJPostguard latest of all items? What does a raw table look like?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
I have a dataset which includes the date, stock availbity, and how many shipments were made. I constantly add to this list daily to add new stock count. Same items are being added each time, just different dates, and quantity per day as well as shipments. I would like to reflect the most recent quantity(Available column) on power bi corresponding to each item in the table ( about 25 items quantity quotes that need to be displayed). I would like power bi to grab the latest date and also the quantity. and also be able ot refresh the dataset when new data is added daily. Thank you!
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
