Lookup value from one table from another

[NadaBen]

Hello,

i'm working on a project on Power BI but i'm still a beginner, so i need some help 🙂

i have table 1 :  "semaine"  and table 2 : "stock projeté"

Table 1 : Semaine

Table 2 : stock projeté

I have a relation 1 to many between Table 1 and 2. (key : ComonPeriod.Week)

--> i want to get the last day of week of my common period.Week of my table 1 from the column "last day of week" of table 2.

Thanks in advance 🙂

[Anonymous · Accepted solution]

Try as a column in your table 2 (you might need to check field/table spellings)

LastDayOfWeek = LookupValue('semaine'[Last Day of Week], 'semaine'[Common Period.Week], 'stock projeté'[Common Period.Week])

[NadaBen]

i tried the formula, but it didn't work, i have a blank in all my column

[Anonymous]

You are trying to create a calculated column that pulls down the value from the Semaine table?  In general, that is "not needed" -- you just use the value from Semaine.

But likely the calc column would be:

stock projeté[NewColumn] = RELATED(Semaine[Last Day Of Week])

[NadaBen]

i'm using a custom calendar, so when i import data from the BI, my week is like "Week 1,2017", and when i want to make date functions on my  week i can't do it because when i change the type to date with power bi it gives me a weird number", so i'm trying to get "the last day of week " from table "semaine", and then make date functions on this date.

By the way i tried your formula, it gives me always 07/05/2017!