Forum Discussion
Renaming Field-Parameter issue
I does look like a bug, I agree.
BTW I wasn't trying to imply that a calculated column is "better" (normally it is advisable to avoid calculated columns where possible, so writing the code into the table constructor is probably better). I was suggesting an alternative way to include the columns as per the original poster's needs seeing as changing the column name wasn't working.
PaulDBrownAh ok, I understand what you mean now. Yes, we can define a formula that does the job, but maybe there are cases where it is more readable to do it directly on the defining power query formula. For some cases (table of field parameters with a few rows) maybe I'd rather see it written like this, instead of having a switch formula. But whether this is a "better way" of course is subjective! In any case, at the end of the day I do believe that there is a bug here worth reporting.
I does look like a bug, I agree.
BTW I wasn't trying to imply that a calculated column is "better" (normally it is advisable to avoid calculated columns where possible, so writing the code into the table constructor is probably better). I was suggesting an alternative way to include the columns as per the original poster's needs seeing as changing the column name wasn't working.
Yes, I understand! That was a working alternative indeed.