Forum Discussion
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 ...
NOw you can use this MEASURE
Value at Recent Date = CALCULATE ( SUM ( TableName[Value] ), FILTER ( TableName, TableName[Date] = MAX ( TableName[Date] ) ) )
NOw you can use this MEASURE
Value at Recent Date =
CALCULATE (
SUM ( TableName[Value] ),
FILTER ( TableName, TableName[Date] = MAX ( TableName[Date] ) )
)
Is this only for one value?
I have now tried it, however I trying to find out if I am able to use this measurein charts?
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.
