Forum Discussion

Helper III

8 years ago

Max value

Hello I have some data, where I want to retrieve the max value from an unpivoted column. I need to retrieve the max value for each "name". I have multiple record for each name, on different date...

Need Help

BiBra

Helper III

8 years ago

Value at recent date = 
CALCULATE(
    SUM('inStock'[Value]);
    FILTER('inStock';'inStock'[ActualStart] = MAX('inStock'[ActualStart])))

I have recently tried this for retrieving the latest data. I tried changing the "ActualStart" to Value. Then I tried to add another FILTER before the SUM funciton, to divide the values into dates. However this is not allowed