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_BHelper III
Helper IIIamitchandak, 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!