Forum Discussion
BiBra
Helper III
Helper IIIlatest 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] ) ) )
Zubair_Muhammad
Community Champion
Community Champion
One of the ways of doing it is to create a Calculated Table
Go to Modelling Tab >>> NEW TABLE
New Table =
SUMMARIZE (
TableName,
TableName[Name],
"Date", MAX ( TableName[Date] ),
"Value 1", CALCULATE (
SUM ( TableName[Value 1] ),
FILTER ( TableName, TableName[Date] = MAX ( TableName[Date] ) )
),
"Value 2", CALCULATE (
SUM ( TableName[Value 2] ),
FILTER ( TableName, TableName[Date] = MAX ( TableName[Date] ) )
),
"Value 3", CALCULATE (
SUM ( TableName[Value 3] ),
FILTER ( TableName, TableName[Date] = MAX ( TableName[Date] ) )
)
)
BiBraHelper III
Helper IIIAny easier way? I have 53 "values"
- Zubair_Muhammad
- Zubair_Muhammad
NOw you can use this MEASURE
Value at Recent Date = CALCULATE ( SUM ( TableName[Value] ), FILTER ( TableName, TableName[Date] = MAX ( TableName[Date] ) ) )- Zubair_Muhammad
Use can then use a MATRIX VISUAL
Put
1) Name is Rows
2)Attribute in Columns
3) Value at Recent Date in Values