If the selected a table cell in the last column, you will see a third option: "Table Columns to the Right." Click "Table Columns to the Left" or "Table Columns to the Right" to insert the new column.

When the ALTER TABLE statement adds a column to the table, it initializes the column's values to missing in all rows of the table. Use the UPDATE statement to add values to the new column (s).

Learn how to add a calculated column in Microsoft Power BI to enrich your data and provide easier insights with this guide.