New Key columns created in Data Table are not available in Transform.

[Anonymous]

Hi,

I am new to Power bi and am attempting to Merge two tables and created two Key columns directly in the Data tables for this purpose.  In my version of Power Bi (Dec 2023), the Merge functionality is contained within Transform.  When the data tables are opened in Transform, the new columns do not appear.  How can I get these to appear? Likewise how can I create the columns in Transform? Thanks.

[Anonymous · Accepted solution]

Hi @Anonymous

Based on the information you provided, I'm assuming, if you created new columns in Power BI but can't see them in the Power Query editor, the possible reasons are:

The columns you create are calculated columns, not custom columns. Calculated columns are created in the data model, not in Power Query. Therefore, you cannot see or edit them in the Power Query editor.

To make new key columns available in the Transform section, you need to create them within the Power Query Editor. Please try the following:

Open Power BI Desktop.

In the Home ribbon, click on "Transform data" to open the Power Query Editor.

In the Power Query Editor, navigate to the table where you want to create the new key column.

Go to the "Add Column" tab, and you can use the "Custom Column" button to create a new column based on a formula, or use other available tools to generate the column you need.

After creating the column, make sure to click "Close & Apply" to save the changes and make the new column visible in the Data view.

You can view the link below for more details:

Add a custom column in Power BI Desktop - Power BI | Microsoft Learn

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Idrissshatila]

Hello @Anonymous , 

your requirement is not clear, can you explain and show us what do you mean.