We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
Your approach didn't seem that "fairly new". That was a pretty outside the box approach; I like how you use a Cartesian product by appending the two tables together and filter the data again, creating a cross join basically.
That was very creative @DEO413
On this solution, I use the same Advanced Join tool previously referenced by @AndrewDataKim The tool makes it really easy to create a custom cross join that reminds me of a cross join I have used in the past with Power Query.
Thanks to @JoeM for guiding me to the advanced join link.
I like your approach to solving this problem; by manually setting the maximum limit of the Tile Cutoffs, you are basically getting a unique value for the Tile Num that you can use on the following join with the Tile Num generated by the unique value of the Range.
I thought I was going to be concerned with the sorting order of the first table of the range values, but the unique value tile tool automatically assigns the lowest tile num to the lowest range values; so even if this table wasn't sorted, the unique value tile tool would assign the correct tile num to match.
Thus, very solid approach.