formula on power query (M language)

[pccamara]

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

[sandy666]

Is that what you want (example)?
Point 1: PQ Editor: steps and Advanced Editor
Point 2: you can use PowerPivot (DataModel)
.

• Microsoft Power Query for Excel
• Power Query M Reference
• Data Analysis Expressions (DAX) Reference
• You can buy some books about PowerQuery and PowerPivot also

---

If that takes care of your original question, & to say Thanks and for better Motivation, please

1. click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
   then
2. select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.

If you did it already - ignore it.
Thank you.

---

[pccamara]

awesome!!!
Thank you so much

[sandy666]

You are welcome

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.