My dear friends
I would love to find a solution for this one, although i can do it in excel. But i need it in power query. The table is quite long, almost 100.000 and increasing maybe till 250.000 at the end of the year.
I'm gonna attach a sample file, but i need in power query, 3 more columns with formulas for each record:
1. I need the first, the last and the average price of cost for each product, item, for company X and of course in this case, type, purchases.
2. I need also the average sell price the cost of good sold and the gross profit.
Finaly, i would like to learn the M language and also DAX for power pivot. Any advice on youtube videos? I know a few but don't like what i see to learn from point zero.
Thank you very much for all your help
Best regards
Pedro
Bookmarks