Forum Discussion
Alexandra_B
Helper III
Helper IIIHierarchy from multiple tables
Hello. Help, please! I have a number of tables in Power BI desktop (loaded JSON files). Each files contains the same columns, but with different values. Please see in the picture above...
Alexandra_B , Append then in single table and use path and path length in DAX
https://www.sqlbi.com/articles/clever-hierarchy-handling-in-dax/
amitchandak
Super User
Super UserAlexandra_B , Append then in single table and use path and path length in DAX
https://www.sqlbi.com/articles/clever-hierarchy-handling-in-dax/
Alexandra_Bamitchandak, thank you.
I have apended them in a single table, but how do I differentiate them?
I have tried to merge them, but I`m getting lost at "Join kind" and then it`s taking ages to load 😞
- Alexandra_B
amitchandak, I`ve sorted it out with Merge and followed the steps from links (path and pathlength). Then I created a relationship between the hierarchy table and the unpivoted merged table and it works. Thank you for your help!