Forum Discussion
Helper IIHow to expand (or include) new column header dynamically in Power BI
Helper IIAshish_Mathur , i'M getting error (saying some image64 not valid etc.,) in the 3rd step ...and i am still not sure based on the video and blog that it will work.
You are trying to kind of merge 2 tables into 3rd one.
I'm trying to just get the data and repopulate the header.
Can you just see/try based on my simple data sets i gave above
TIA
MN
Helper III played with TableExpandTableColumn but i am getting this error
Expression.Error: The column 'Agerange,2017 Q2,2017 Q3,2017 Q4,2018 Q1,2018 Q2,2018 Q3,2018 Q4,2019 Q1,2019 Q2,2019 Q3,2019 Q4,' of the table wasn't found.
Details:
Agerange,2017 Q2,2017 Q3,2017 Q4,2018 Q1,2018 Q2,2018 Q3,2018 Q4,2019 Q1,2019 Q2,2019 Q3,2019 Q4,
Here is the row i added
let
Source = Sql.Database("sqltest", "S_test"),
dbo_tmpView2 = Source{[Schema="dbo",Item="tmpView2"]}[Data],
#"Pivoted Column" = Table.Pivot(dbo_tmpView2, List.Distinct(dbo_tmpView2[Quarter]), "Quarter", "Cnt"),
#"Expanded Column"=Table.ExpandTableColumn(#"Pivoted Column", Lines.ToText(Table.ColumnNames(#"Pivoted Column"),","),List.Distinct(Table.ToList(#"Pivoted Column")))
in
#"Expanded Column"
--- This is the extra row i added
= Table.ExpandTableColumn(#"Pivoted Column", Lines.ToText(Table.ColumnNames(#"Pivoted Column"),","),List.Distinct(Table.ToList(#"Pivoted Column")))
Basically i was trying to show the new data i.e. not selected and showing automaitcally... Am i correct in this.
In other words , i don't want to select the new columns everytime (and that's what i am trying to do)