Hi,

I'm not sure if this can be solved using PQ but, let's see!  🙂

Let's say for the sake of simplifying, I have one monthly report that provides me, one table with YTD values for sales and, for the budget I have monthly values.  So, I'm thinking in having one query for sales with two columns (monthly & cummulative) and, one query for budget with two columns (monthly and cumulative). 

My final intention is to merge these two queries and have budget and sales in the same query so I can run pivot tables/charts from it.

My problem is, how do I build/fill the cumulative for the budget and, how, I calculate the monthly from the cumulative for the sales with Power Query....

Any ideas?  

Thanks!!

Gerardo