Forum Discussion
Find first year value
Hi All, I would like to find the value in the earliest Year. For example, if I filter to [Year ] = 2020, I should see the following. My Year slicer is single selection. BA1 = 21 BA2 = 32 BA3 ...
Try:
min year value =
VAR MinYear = MINX(ALLEXCEPT(Table, Table[Code]), Table [Year])
RETURN
CALCULATE(SUM(Table[Value]), FILTER(ALL(Table), Table[Year] = MinYear))