Forum Discussion

ScottBrown's avatar
ScottBrown
Helper II
1 year ago
Solved

Dimension - Multiple Fact Table Columns Customer Names (BillTo Name, ShipTo Name, EndUser Name)

Structure: I have a dimension table of Customer Names only. The Fact Table has a BillToName, ShipToName, and EndUserName - not always the same. The Fact Table consist of SalesLineItem data, many l...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Thank you DataNinja777

    Hi, ScottBrown 

    Based on your description, I've created the following two tables:

    I think you can unpivot BillToName, ShipToName, and EndUserName in Power Query to turn it into a 1D table that Power BI accepts:

    Finally, you can establish a connection to your CustomerNames dimension table and filter the corresponding data by the type column.

     

     

    Best Regards

    Jianpeng Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, ScottBrown 

I wish you all the best. Previously we have provided a solution to help you solve the problem. Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

 

 

Best Regards

Jianpeng Li