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 ...
Anonymous, Try the below code in measure
CALCULATE(SUM(Table[Value]), Table[Year] < 2020)