What is the faster way to add one more field name SOURCE and fill with value = Singapore i?

[Anonymous]

Hi All

I need to add one more filed , as i dont want to add the field at excel raw data. Hope some one can advise me the faster way.

[Daviejoe]

Or you can go into the Query Editor and add a Custom Column there

= "Singapore"

[Daviejoe]

[Anonymous]

Hi Sir

Thank you for sharing the screen shot . which is the better approach to add quary or at PBI screen ?

Paul

[Daviejoe]

Personally @Anonymous I generally try to do as much as possible in Power Query.

[Daviejoe · Accepted solution]

You can add a new column if your table is going to be small

New Column Name =

"Singapore"