Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

DATA MODELING

In Power BI, I have two tables with the same columns. Table 1's data comes from the server, and Table 2's data comes from Excel. T1's data is from one month back, and T2's data is from the current mo...
Need Help
  • Daniel29195's avatar
    Daniel29195
    2 years ago

    i understand you.

    you can using dax create w caluclated table : 

    DimCustomers = 

    var customers_table_1 = distinct( t1[customer_column])

    var customers_table_2 = distinct( t2[customer_column])

    RETURN

    distinct( 

    union ( customers_table_1   , customers_table_2 ) 

     

    then you link this table to both t1 and t2 table base on the customer field. 

     

    then in your visuals, you read the customer data from the newly created table :  DimCustomers.

     

    will this solve it ? or am i missing something ? 

Daniel29195's avatar
Daniel29195
Icon for Community Champion rankCommunity Champion
2 years ago

i understand you.

you can using dax create w caluclated table : 

DimCustomers = 

var customers_table_1 = distinct( t1[customer_column])

var customers_table_2 = distinct( t2[customer_column])

RETURN

distinct( 

union ( customers_table_1   , customers_table_2 ) 

 

then you link this table to both t1 and t2 table base on the customer field. 

 

then in your visuals, you read the customer data from the newly created table :  DimCustomers.

 

will this solve it ? or am i missing something ?