Forum Discussion
dynamic columns display in table selection
i have a table with column names A1 A2 A3, i created in power query as dynamic column names and created a visual table with A1 A2 A3 and other selections. next month the column names changes to B1 B...
Anonymous , in such case they should be in rows not column. Try to unpivot those
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/