Forum Discussion
Solved
ADF pivot vs fabric dataflow pivot
there is a powerful pivot activity in ADF dataflow. the pivot in fabric dataflow gen2 does not seem to have quite the same functionality as that in ADF. for example: in ADF dataflow pivot it has th...
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.
I'm not familiar with ADF dataflows.
Could you visualize what you want to achieve?
E.g. create some small dummy data in Excel and visualize how you want that data to be pivoted and grouped or aggregated.
please see attached the sample data showing initial data and the required data.
There does not seem to be an optioni to include a sample file so I attached the screen-shots.
hopethis helps
thank you
