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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Dmoetnogleren
Regular Visitor

Question about Vlookup multiple values

Dmoetnogleren_0-1718025582489.png

 

1 ACCEPTED SOLUTION
xifeng_L
Super User
Super User

Hi @Dmoetnogleren 

 

You can refer to below calculated column.

 

xifeng_L_0-1718034695996.png

 

RecentStartDate = LASTDATE('Fact'[Start Date])

 

Note: need to create relationship.

 

 

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

 

Thank you~

 

View solution in original post

3 REPLIES 3
Dmoetnogleren
Regular Visitor

Thank you, this was a good solution!

Anonymous
Not applicable

Hi @Dmoetnogleren ,

 

Did @xifeng_L  reply solve your problem? If so, please mark it as the correct solution, and point out if the problem persists.

 

Best Regards,
Adamk Kong

xifeng_L
Super User
Super User

Hi @Dmoetnogleren 

 

You can refer to below calculated column.

 

xifeng_L_0-1718034695996.png

 

RecentStartDate = LASTDATE('Fact'[Start Date])

 

Note: need to create relationship.

 

 

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

 

Thank you~

 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

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.