Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help to create a column with data from table B in table A

Hello,

 

I'm newbie with Power BI and always that I with some trouble you guys help me and I appreciate for this.

 

Well, here I am with one more trouble.

 

I have two tables:

 

Table "Before:"

WeekOrderRowError
20107200485101095
20107200485201095
20107241520201095
20107241520401095
20107241520901095
201072448752601095

 

Table "After":

WeekOrderRowError
2010720048510G9
201072004852095
201072415204095
201072448752601095

 

So what i need?

I need to create a measure (or column, whatever it's easier) on table "Before" to see the column "ERROR" from "After" but the rows from Before that doen't exist on "After" must be filled with "Done"

 

Expected output:

Table "Before"

WeekOrderRowErrorError After
20107200485101095G9
2010720048520109595
20107241520201095Done
2010724152040109595
20107241520901095Done
2010724487526010951095

 

I linked both tables using the following relantionship:

 

Base 1 = Table Before

Base Chile LBD = Table After

PL = Columns Order + Row (to create a unique key)

 

That's it, i hope someone could help me and if i wasn't clear enough, please, let me know

  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous,

    I think you can create a calculated column with lookupvalue function to get value from another table based on relationship keys. (notice: the table relationship not necessary)

    LOOKUPVALUE function (DAX) - DAX | Microsoft Docs

    Regards,

    Xiaoxin Sheng

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous,

    I think you can create a calculated column with lookupvalue function to get value from another table based on relationship keys. (notice: the table relationship not necessary)

    LOOKUPVALUE function (DAX) - DAX | Microsoft Docs

    Regards,

    Xiaoxin Sheng