Power Query - Dataset Transformation

[Anonymous]

I have the following dataset from dataflow and some additional steps in power query. 

Now that I have this, is there anyone that can guide on the best method to transform as follows:

[Anonymous]

I have managed to get this data in the right format.

[Anonymous]

Hi @Anonymous ,

I'm not quite sure what your needs are, are you trying to convert the data in that screenshot above to the format in the one below, or are you trying to convert the data in the screenshot below to the format in the one above?

Best Regards,
Dino Tao

[Anonymous]

I have the top and want to transform to the below.

[Anonymous]

Hi @Anonymous ,

Neither M code in Power Query nor DAX in Power BI Desktop enables splitting a table and adding a TOTAL row for each sub-table. My suggestion is that you put the table into a matrix visual object and set both the column Entity and the column Vendor Number to the row headers.
Or you can try using Report Builder to create a paginated report.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dufoq3]

It is possible with M, but this is not purpose of PowerQuery.

[Muhammad_Ahmed]

Hi,
This can be done inside power query by taking advantage of the m language.

[Anonymous]

Thanks - this is what I intent to do - it's the syntax of the m language that I am looking for some guidance with.

[lbendlin]

This is the best source on M, by far: https://bengribaudo.com/blog/2017/11/17/4107/power-query-m-primer-part1-introduction-simple-expressi...