Forum Discussion

BiBra's avatar
BiBra
Icon for Helper III rankHelper III
8 years ago
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       ...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    BiBra

     

    NOw you can use this MEASURE

     

    Value at Recent Date =
CALCULATE (
    SUM ( TableName[Value] ),
    FILTER ( TableName, TableName[Date] = MAX ( TableName[Date] ) )
)
PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
8 years ago

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.

BiBra's avatar
BiBra
Icon for Helper III rankHelper III
8 years ago

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's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion
    8 years ago

    BiBraOK, sorry...