Forum Discussion
Helper IIIlatest Values
NOw you can use this MEASURE
Value at Recent Date = CALCULATE ( SUM ( TableName[Value] ), FILTER ( TableName, TableName[Date] = MAX ( TableName[Date] ) ) )
Helper IIIThis 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?
Community ChampionBiBraSorry, 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.
- BiBra
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.
- PaulDBrown
BiBraOK, sorry...