Notifications
Clear all
Power Query
3
Posts
3
Users
0
Reactions
1,239
Views
Hi,
The file attached has 2 unneeded columns (Plot2 & Year3).
These columns were added to the file and cannot actually be deleted. Trying to delete result in strange behaviour, like 1 column is deleted but not the other, or it add another column.
You can see in the PQ steps that those columns were never added.
Regards,
Ayal Telem.
Posted : 21/10/2024 7:31 am
Poping topic up since there is no reply, which I find odd.
Regards,
Ayal Telem.
Posted : 29/10/2024 1:37 am
Hello,
If you remove the AllYears query, you can then delete those two columns in the table and then add the AllYears table into Power Query again.
Br,
Anders
Posted : 29/10/2024 4:40 pm