Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Profit Report

Hi there   I need to build a profit report as I have 3 tables as the following:      A- Table 1 contains:           1- Revenue amount           2- Revenue Date           3- Project ID         ...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous ,

     

    To create another new calculated table as a bridge table, and create relationship between your fact tables.

    Project =
DISTINCT (
    UNION (
        VALUES ( table1[projectid] ),
        VALUES ( table2[projectid] ),
        VALUES ( table3[projectid] )
    )
)
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

 

To create another new calculated table as a bridge table, and create relationship between your fact tables.

Project =
DISTINCT (
    UNION (
        VALUES ( table1[projectid] ),
        VALUES ( table2[projectid] ),
        VALUES ( table3[projectid] )
    )
)