This looks at a scenario of a hierarchy but the child ID repeats and we can't create a relationship on it. Adam looks at how you could use a surrogate key to get a relationship in place so you can build your Power BI report.

Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET'S CONNECT!
*******************

  / guyinacube  
  / awsaxton  
  / patrickdba  
  / guyinacube  
  / guyinacube  
https://guyinacube.com

**Gear**
Check out my Tools page https://guyinacube.com/tools/

#PowerBI #PowerQuery #GuyInACube