Forum Discussion
Add multiple columns in power bi
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,
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
1 Reply
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