Max value

[BiBra]

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 dates. What I want to get is the nmax value for each name. 

I have tried the following:

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: 

This is no matter which visual I try to represent it in. Is there any way to make this happen?

[SivaMani]

@BiBra,

It would be great if you share sample data.

[BiBra]

@SivaMani

It looks somewhat like this:

name               date               attribute              value

xx                   9/10-2016           hgr                     3

xx                  20/11-2016          hgr                      5

sdf                 ---                        we                       1

Where attribute and value are the unpivoted ccloumns

[BiBra]

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]

@BiBra,

If your requirement is finding max value, MaximumVal = MAX('inStock'[Value]) - this will give expected outcome.

Was I understood wrong? 

[BiBra]

@SivaMani It is not only the max value, but the max value of each target/name