Forum Discussion
Custom filtering table based on a slicer value
I need to show [FTE] measure only for the current and previous year.
this is not working since it only shows the current year.
FTE_WL1 =
Var prev_yr = MAX('Date'[Year])-1
RETURN CALCULATE([FTE],FILTER(ALL('Date'[Year]),'Date'[Year]>=prev_yr))
any help is appreciated, thank you.
2 Replies
Well this will calculate the fte for 2 years combined. If you want both years separated, then use 2 measures.
Fte
and the new one but change >= to be =
