Sep 20 2021 01:55 AM
Sorry - dificult to describe the problem I am having in the subject line
Basically relatively new to Power Query
I am creating custom columns to create data and then use the new data in pivot fields- however when I edit my code and say change one of the data entries - the old data entries still appear in my pivot tables
ie
say I have a custom column that looks for something in another column and uses an if statement and puts in the new column - so look for "Apples" in Column "Basket" and puts "Fruit" in the column.
However if I go back and edit the code and replace "Fruit" in my if statement with say "Fruits" - both "Fruit" and "Fruits" are returned as options in my pivot table - even though there are no longer any "Fruit" in my column and the code has been changed to not use "Fruit" as an entry
More annoying - but as I am then using Slicers in my pivot tables the option of "Fruit" still shows
Sep 20 2021 02:01 AM
Try to fix your table in memory before pivoting. You may add Index column or use Table.Buffer().