Recursive functions are a topic that I rarely come across.
To give you some perspective, the instances that I’ve needed recursive functions can be counted with just 1 hand.
This is one of those situations where a recursive function is probably the best way to go.
Big thanks to NicoPer who posted this question on the Official Microsoft Power Query forum.
Excel specialist turned into BI specialist using the latest tools from Microsoft for BI – Power BI. He is the co-author of ‘M is for Data Monkey’, blogger and also Youtuber of powerful Excel video Tricks.
He has been recognized as a Microsoft Most Valuable Professional (MVP), is a Microsoft Certified Professional (MCP – MCSA: BI Reporting), a Microsoft Certified Trainer (MCT), and is one of the international pioneers in Power Pivot, Power Query and Power BI.