I may have found a solution.... At first I was trying to run the query in the original workbook with all the data. I have now copied the M code int...
Hi Mynda, I'm only deleting data within a worksheet, not the full worksheet, and the data is still in the query. It's almost like it's not 're-fetc...
Thank you!!! I knew it was something simple!
Hi Catalin, When I click 'Ignore Privacy Levels..' I'm just taken back to 'Information is required about data privacy' error.
Success! = Table.AddColumn(#"Added Conditional Column9", "Custom.10", each if [category2] = null then [Textbox12] else [Textbox10]) I basically ...
Hi Catalin, I was working through your index column suggestion but then realized that it won't work because I will be adding data every month and t...