Hi good day,
Can anyone help me on my lookup value. I have two table and i want to look up the value from table 2 but filter by year. Pls refer below.
RESULT
Thank you
Hi @AllanBerces ,
What I suggest is creating a new column in table01 and using calculate instead of lookup value. See below:
Progress2023 = CALCULATE(MAX(Table2[Daily Progress]), Table2[Year]=2023 , Table2[Work]=Table2[Work])For every year we are creating a new column to calculate the max value to the corresponding work column and year
Hi @AllanBerces ,
What I suggest is creating a new column in table01 and using calculate instead of lookup value. See below:
Progress2023 = CALCULATE(MAX(Table2[Daily Progress]), Table2[Year]=2023 , Table2[Work]=Table2[Work])For every year we are creating a new column to calculate the max value to the corresponding work column and year
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
