Forum Discussion
ADF pivot vs fabric dataflow pivot
I created the helper row by using Enter Data. Then I copied the generated M code into the main query manually.
But you can do it easier:
You can create it as a separate query by using Enter Data, and then appending that query to your main query by using the menu option for Append queries.
3 - yep, you could try that. Perhaps that also solves 1 and 2?
Ultimately, there are probably several ways to solve the case, depending on your specific needs.
The code I made was my initial thought, based on the sample data / screenshots provided.
In essence, I think the case is about pivot with multiple value columns. Googling for "Power Query pivot with multiple value columns" might provide useful answers.
You can also consider posting in the Power BI -> Power Query forum, since the case is about using Power Query to transform the data:
https://community.fabric.microsoft.com/t5/Power-Query/bd-p/power-bi-services
It is easier to provide guidance when knowing the full nature of your actual data (e.g. knowing all columns) and more details about your specific needs. However I totally understand if you cannot share more details about the actual data online due to business confidentiality, etc.
did you create the custom function by hand or via menu?
I tried adding the dummy row but had to copy paste your code in the script section
you have been a wonderful help. thanks ever so much.
I created the helper row by using Enter Data. Then I copied the generated M code into the main query manually.
But you can do it easier:
You can create it as a separate query by using Enter Data, and then appending that query to your main query by using the menu option for Append queries.