Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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))
Capturex.PNG

 any help is appreciated, thank you.

2 REPLIES 2

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 =



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Anonymous
Not applicable

thanks, is there a way to show both years in the same graph using a single measure. 

Capturex.PNG

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.