APQ18 | From total YTD to monthly amount | Deconstruct YTD total | Advanced Power Query

[@jerrydellasala7643]

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!

[@aaaexcelenglish]

Agree 100%, thank you

[@agostinhosubtil569]

Another fantastic explanation. Thank you very much and good year 2025.

[@aaaexcelenglish]

Thank you so much and happy 2025 to you too

[@sandipsoni4047]

Thanks this video solve real life problem

[@aaaexcelenglish]

Happy to hear that

[@leosaghathan2895]

Very clear thank you

[@aaaexcelenglish]

You are welcome

[@getsetgoo3334]

great tutorial

[@aaaexcelenglish]

Thank you 🙏

[@fernandopaula7628]

Thanks! APQ 17 is not available?

[@aaaexcelenglish]

Not yet! 😁

[@aaaexcelenglish]

The Arabic version only

[@sujanmdsiful]

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]

Good idea, what you are going to do if you have more than one product and more than one year?

[@sujanmdsiful]

@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

[@aaaexcelenglish]

Yes, it will work, perhaps with better performance. Thank you for sharing your thoughts