Forum Discussion

Daniel48's avatar
Daniel48
Helper I
2 years ago
Solved

Adding Calculated Column with the latest Item

Hello,   I have tried many different ways and I can not seem to make this work.   I have a list of items   Category    Date  Current           New Colum X01  01/01/2018    ABC                 A...
Need Help
  • quantumudit's avatar
    quantumudit
    2 years ago

    You can use the following DAX formula to create a calculated column:

     

    Latest Value = 
VAR _currentCategory = Data[Category]
VAR _maxDate =
    CALCULATE (
        MAX ( Data[Date] ),
        FILTER ( Data, Data[Category] = _currentCategory )
    )
VAR _leastVal =
    CALCULATE (
        MAX ( Data[Current] ),
        FILTER ( Data, Data[Date] = _maxDate && Data[Category] = _currentCategory )
    )
RETURN
    _leastVal

     

    Here is the solution screenshot:

    Make sure to leave a kudo if it resolves your issues...

     

    Thanks 😊

     

     

     

quantumudit's avatar
quantumudit
Super User
2 years ago

Maybe create a new ticket and show exactly what you want to achieve and then, I will check it out