It was about a week ago when I published a blog post about transitive closure in Power Query: https://community.powerbi.com/t5/Community-Blog/Transitive-Closure-in-Power-Query/bc-p/786063. As you can...
Nolock: Additional information. I created a small, straightforward testset with from-to's as follows: 1-2, 2-3, 3-4, and so on until 16-17 and then 17-1. At me, until 16 and then 16-1 is OK, but then it stops. I have the idea this is more or less happening with my real dataset.
