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] ) ) )
Community ChampionCommunity Champion
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
BiBraIs this only for one value?
- Zubair_Muhammad
- BiBra
I have now tried it, however I trying to find out if I am able to use this measurein charts?
- BiBra
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?
PaulDBrownBiBraSorry, 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.