Forum Discussion

BradRose's avatar
BradRose
Helper I
9 years ago
Solved

Creating a new table in Power BI

    Here the data we have currently in our Fact Table, I can create a unique key on Customer / Business   Fact Table Customer Business Date Dollar Sales FactKey Kroger ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi BradRose,

     

    In my opinion, I think you can create a new table with unique customer and business value, then use the new table to link two tables.

     

    Steps:

    1. Create a calculated column to merge customer and business.

    Customer Business = [Customer]&" "&[Business]


    2. Use customer business to create a new table.

     

    Customer Business = VALUES('Fact'[Customer Business])

     

    3. Create relationships between fact, employee and above table.

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi BradRose,

 

In my opinion, I think you can create a new table with unique customer and business value, then use the new table to link two tables.

 

Steps:

1. Create a calculated column to merge customer and business.

Customer Business = [Customer]&" "&[Business]


2. Use customer business to create a new table.

 

Customer Business = VALUES('Fact'[Customer Business])

 

3. Create relationships between fact, employee and above table.

 

Regards,

Xiaoxin Sheng