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] ) ) )
PaulDBrown I am not referring to your solution. I am referring to Zubair_Muhammad. When using his method. it works when the unpivoted column only contains 1 and 0, not when values higher.
BiBraOK, sorry...