I have two tables:
The timetable of my project is set by week number and in the periods table I have the dates associated with each week number.
How can I apply the simple "Vlookup" of Excel in Power BI for example for "Actual Beginning"
Attached screenshots of my tables:
Go to Solution.
From your description, it seems that you want to return corresponding Periods values for Actual Beginning column, right?
You can create a calculated column in Timetable with LOOKUPVALUE Function below:
Column = LOOKUPVALUE('Periods'[Periods],'Periods'[Weeks],'Timetable'[Actual Beginning])
Best Regards,Qiuyun Yu
View solution in original post
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.