Forum Discussion

DenisOHara's avatar
DenisOHara
Frequent Visitor
5 years ago
Solved

Power BI Relationships

Power Bi . I have three tables A,B,C A is a table of postcodes with a one to many reationship to table B of Clients which in turn has a one to many relationship to table C a transaction table. I want...
  • DenisOHara's avatar
    DenisOHara
    5 years ago

    Hi

    I got it sorted, I had not defined all the realtionships

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Rajiv,

 

Could help me to find out how can I do the operation below?

 

I have 2 tabs

 

1 - Main one - With all the information Names + Actual Date (Date) and Status (Open) of the process

2 - Update data - With Names + Actual Date (Date) and Status (Close) of the process

 

What I need to do is:

 

Take the information from the 2 (Update data Excel) and check if I can find the names in the 1(Main one) excel, if the names are matching, I need to Add the new Actual Date (from - 2(update data) excel) into the 1(Main one), and I need to check the New Status from (2 - Update data) into (1 - Main one) chance from open to close.

 

So the (1 - Main one excel) would have the update iformation of the New Actual Date and the Status will be change from open to close

 

so, If the Names between the 2 tables match, the (1-Main information) will get New actual Date and the Status will be change from actual Open to Close.

 

how can I do it?

 

Thank you