In this Excel tutorial, you will learn how to Calculate Hierarchy Levels with Recursion | Power Query 22 📖 Get my book about Power Query here: 👉 Amazon: 👉 Publisher BPB: Formula: none ---⏱️Timestamps⏱️--- 0:00 Introduction - Finding hierarchy levels in MLM/company structure 1:25 Setting up Power Query - Importing data and creating blank query 2:21 Building the recursive function - Finding person ID and referrer 4:49 Applying the function to the table and fixing table references 6:34 Testing the function - Changing referrer and verifying results 7:03 Conclusion ================ Files to download in the Eng folder on the website: You can also find me on: 📚Blog - 🍀Instagram - 🌟Tik Tok - @excelandadam ✨Facebook - 🕊Twitter - #ExcelAndAdam #ExcelTips #excel