Forum Discussion

Daniel48's avatar
Daniel48
Icon for Helper I rankHelper 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
Icon for Super User rankSuper User
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 😊

 

 

 

Daniel48's avatar
Daniel48
Icon for Helper I rankHelper I
2 years ago

Worked perfectly. Thank you for your help!