Add Custom column in Power Query (Excel)

[Recoba88]

Hi,

2 question:

1. When I add custom column in loaded data to excel worksheet I don't see this column in power query, why?

2. Where I should add custom columns to loaded data or power query editor? what is the difference ? (calculation time and etc.)

Thanks !!

[v-huizhn-msft]

Hi @Recoba88,

Your desciption is confusing, besides the solution @DoubleJ posted, could you please share more details and describe clearly for further analysis?

Best Regards,
Angelia

[DoubleJ]

Where did you add the column? If you did inside Power Query then you should see it there. If you added it in Power Pivot then it is "too late".  

Power Query is used to load the data from a source into the Power Pivot model inside Excel. 

It really depends what you want to do with the data in that column. If you want to do further transformations you should do it in PQ. Generally, it's much easier to do it there. In case you need it to do more complex calculations PowerPivot probably is the better place.