Add multiple columns in power bi

[ktt777]

when i load data into power bi, there are already 5 column named A,B,C,D,E.

What is the fast way to add multiple columns with names : F,G,H,K,L,M,N... with null value to the database.

I will change the value of the column later

thanks,

[FarhanAhmed · Accepted solution]

Create a Table with 2 columns 

e.g.

-- ColumnName -----Value

Put the number of  Columnname in columnname field and keep values as null

then go to advance editor 

Pivot this table

with "No Aggregate"

you will get the result as single row with multiple column

Now 2 ways

Go to DAX and create a cross join between 2 tables one is source other is new columntable

CROSSJOIN function (DAX) - DAX | Microsoft Docs

2nd 

Go to Power query and Add the column

in formula field put the name of table

Expand the table in and you will get multiple columns in quick way

Cross join - Power Query | Microsoft Docs