Forum Discussion

Ireneliu's avatar
Ireneliu
Regular Visitor
7 years ago

Difference between two tables

Hello Everyone,   I have a question about the diference between two tables. A Table is for department's actual results. B Table is for department's budget. When the actual results have a value, ...
Ireneliu's avatar
Ireneliu
Regular Visitor
7 years ago

I followed up the steps you suggested but having a trouble in step 3.

The relationship between Calendar table and both budget and actuals can't be active at the same time.

Stachu's avatar
Stachu
Community Champion
7 years ago

Hmm, that's probably because of the many:many relationship

 

can you add a new table for Departments, e.g. like this:

Departments =
DISTINCT (
    UNION ( VALUES ( TableA[Departments] ), VALUES ( TableB[Departments] ) )
)

deactivate/remove your existing many:many relationship between Actuals and Budgets

create new 1:many relationships from Departments to tables A and B

do the same for the Calendar table

  • Ireneliu's avatar
    Ireneliu
    Regular Visitor
    7 years ago

    Sorry for late reply.

    I tried to change the relationships.

    However, when I choose Retirement pension to make sure the difference value is right or not,
    finding out the value of Actural results of Salary is included.

    Is it because of there is no relationship about AccountName between table A and B?

    • Ireneliu's avatar
      Ireneliu
      Regular Visitor
      7 years ago

      I create a new table for Account Name and make 1:many relationships from Account Name to tables A and B.

      Finally,getting the right value.