Max value

Question

Hello&nbsp;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". &nbsp;I have multiple record for each name, on different dates. What I want to get is the nmax value for each name.&nbsp;I have tried the following:&nbsp;Max value = 
VAR myValue = [Value at recent date]
RETURN 
CALCULATE(
    Values('inStock'[ActualStart]);
    FILTER(
        ALLSELECTED('inStock'[ActualStart]);
        CALCULATE(SUM('inStock'[Value]))=myValue))However, when trying to display the data the following fault appears:&nbsp;This is no matter which visual I try to represent it in. Is there any way to make this happen?

sivamani · Answer

BiBra,&nbsp;It would be great if you share sample data.

bibra · Answer

SivaMani&nbsp;It looks somewhat like this:&nbsp;name &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; date &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; attribute &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;valuexx &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9/10-2016 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; hgr &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3xx &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20/11-2016 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;hgr &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5sdf &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; --- &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;we &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp;&nbsp;Where attribute and value are the unpivoted ccloumns

bibra · Answer

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

sivamani · Answer

BiBra,&nbsp;If your requirement is finding&nbsp;max value, MaximumVal =&nbsp;MAX('inStock'[Value]) -&nbsp;this will give expected outcome.&nbsp;Was I understood wrong?&nbsp;

bibra · Answer

SivaMani&nbsp;It is not only the max value, but the max value of each target/name

Forum Discussion

Max value

5 Replies

Related content

Find MAX Value within a column

Total Min/Max measure where and keep the value static

Max value with a subcategory

Max Date Values

Max value based on filter