Forum Discussion

Helper III

8 years ago

Solved

latest Values

Hello, I am trying to find out how to get the latest values. Dummy data: Name Date Value 1 value2 value 3 sd 12/10-2017 ...

8 years ago

NOw you can use this MEASURE

Value at Recent Date =
CALCULATE (
    SUM ( TableName[Value] ),
    FILTER ( TableName, TableName[Date] = MAX ( TableName[Date] ) )
)

Helper III

8 years ago

I have now tried it, however I trying to find out if I am able to use this measurein charts?

Community Champion

8 years ago

Not sure if this will work, but it might be worth a try:

last value = CLOSINGBALANCEMONTH([value], date[date])

EDIT: If the preriod you are looking at is a whole year, use CLOSINGBALANCEYEAR instead.