Excellent! Once the example was done, I found it a bit cleaner although a bit trickier to use Date.Month and Date.Year in the Queries saving some steps instead of having to add and remove helper columns. Nicely done either way!
Why are you using so complicated method? You could just create two index columns. First column will start from 1, 2nd column will start from 0. Then you do merge query join from column first index and 2nd index. That's it. Super simple
@aaaexcelenglish I will use same method but I will add groupby step then all rows. In all rows column I will add these 2 index columns. Performance is faster
Excellent! Once the example was done, I found it a bit cleaner although a bit trickier to use Date.Month and Date.Year in the Queries saving some steps instead of having to add and remove helper columns. Nicely done either way!
Agree 100%, thank you
Thanks this video solve real life problem
Happy to hear that
Very clear thank you
You are welcome
great tutorial
Thank you 🙏
Another fantastic explanation. Thank you very much and good year 2025.
Thank you so much and happy 2025 to you too
Thanks! APQ 17 is not available?
Not yet! 😁
The Arabic version only
Why are you using so complicated method?
You could just create two index columns. First column will start from 1, 2nd column will start from 0. Then you do merge query join from column first index and 2nd index. That's it. Super simple
Good idea, what you are going to do if you have more than one product and more than one year?
@aaaexcelenglish I will use same method but I will add groupby step then all rows. In all rows column I will add these 2 index columns. Performance is faster
Yes, it will work, perhaps with better performance. Thank you for sharing your thoughts