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.
How do I use your code?
Can you guide me to create this ib the dstafkow
Tgankyiu
Inside the Dataflow Gen2, you can click Get Data -> Blank query, and then paste the code inside there, then click Next.
I am now implementing your suggestion on the whole actual data. but not sure why the remove duplicates only returns one row whereas it should return four rows similar to the example I sent you
In the remove duplicates step, you need to specify which columns shall be considered when comparing the rows.
If the difference between the rows exists in some column which is not specified in the removed duplicates step, then it will not detect that there is a difference between those rows.
So you will need to specify which columns to check.
Currently, it is only checking the columns which are mentioned here:
{"venture_number", "book", "movement_name", "strategy", "name", "actual_date", "estimated_date", "gross", "net", "actual", "percentage"}for the unpivot, which columns do I need to select first? thanks