Don't sum an Inventory value

Hi Anonymous m

Did you try writing a measure like this?

Last Date Value =

CALCUALTE(
   SUM(Table[Value Column]),
   LASTDATE(table[Date Column]
)

The date column needs to have a date format. The measure checks the dates in scope (based on your filter) and selects the last avaiable. Then it takes only the sum for the values for this last date. I use it in nearly every scenario where I work with balance values. There might be some changes required based on your requirements and data model but in general that should to it when I udnerstand your request correctly.

Best regards

Michael

-----------------------------------------------------

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

@ me in replies or I'll lose your thread.