Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

MS Project baseline tracking

Dear all, need Your help on tracking baselines in Projects. I apologize in advance for the format or mistakes as I'm a total newbie to this "measures" and "tables" world. 1) I want to get into the...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI Anonymous,

    It seems like you are working with two tables that not contain unique field values.
    In my opinion, I'd like to suggest creating a calculated table with dax formulas to extract values from two tables and remove duplicate rows.

    Bridge =
DISTINCT (
    UNION ( ALL ( ProjectBaselines[Project Id] ), ALL ( Projects[Project Id] ) )
)

    After these steps, you can use this 'bridge' table to link two tables and use bridge table key and raw table fields with 'aggregate' function/methods(e.g. max, min...) to get specific values.

    How to join many to many with a bridge table in POWER BI 

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI Anonymous,

It seems like you are working with two tables that not contain unique field values.
In my opinion, I'd like to suggest creating a calculated table with dax formulas to extract values from two tables and remove duplicate rows.

Bridge =
DISTINCT (
    UNION ( ALL ( ProjectBaselines[Project Id] ), ALL ( Projects[Project Id] ) )
)

After these steps, you can use this 'bridge' table to link two tables and use bridge table key and raw table fields with 'aggregate' function/methods(e.g. max, min...) to get specific values.

How to join many to many with a bridge table in POWER BI 

Regards,

Xiaoxin Sheng