Forum Discussion
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...
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
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