Forum Discussion

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 : 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

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])

4 Replies

Anonymous
Not applicable
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])
- NadaBen
  Helper I
  9 years ago
  i tried the formula, but it didn't work, i have a blank in all my column
  - 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])

Related content