Forum Discussion

NadaBen's avatar
NadaBen
Helper I
9 years ago
Solved

Lookup value from one table from another

  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 : ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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])
Anonymous's avatar
Anonymous
Not applicable
9 years ago

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's avatar
NadaBen
Helper I
9 years ago

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!