Vlookup in Power BI

[nhol]

Hi,

I have two tables:

1) Periods

2) Timetable

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"

Thanks!

NH

Attached screenshots of my tables:

[v-qiuyu-msft · Accepted solution]

Hi @nhol,

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