Forum Discussion
Get highest value per group
Hi all. Hope you are able to help me. I have read a similar post about filtering on the highest value per group, but this unfortunately does not solve my issue. Here goes.: I have a data tabl...
I'm thinking:
Customer =
VAR __max = MAXX('Table',[Year])
VAR __filemax = MAXX(FILTER('Table',[Year]=__max),[File name])
VAR __table = FILTER('Table',[File name]=__filemax)
RETURN
__table
Do I create a new table or column?