Forum Discussion
latest Values
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] ) )
)
This works on one of my unpivoted columns thank you!
It works on the column containing only 1 and 0 data. However I have another column,
where I want to do the same, however this column contains data that exceeds 1 and 0.
How can I make that work?
BiBraSorry, I'm not sure if you are referring to my suggestion. If so, can you explain further what the problem is? the function CLOSINGBALANCEMONTH or YEAR returns the last (date) value in a column. In other words, the field "value" must be in the same column in a table.
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...
