Forum Discussion

marcus_giddings's avatar
marcus_giddings
Frequent Visitor
4 years ago

visuals stop working with dynamic column names

hi all , i have a dashboard that uses weekly sales data from a sql server the table i have looks somthing like this.   date_lw sales_lw date_2w sales_2w date_3w sales_3w date_4w sales_4w ...
Need Help
marcus_giddings's avatar
marcus_giddings
Frequent Visitor
4 years ago

somthing i have tried is when changing the column names via power query is instead of referencing the column that i want to change by what is name it content i have tried by referencing the column position in the table by using quueries simalr to this 

 

= Table.RenameColumns(#"Changed Type",{{Table.ColumnNames(#"Changed Type"){3}, dbo_QLIK_WEEKLY_HOURS_no_append[Date_lw]{0}}})

 

this also doesnt work

  • Thejeswar's avatar
    Thejeswar
    Super User
    4 years ago

    Hi,

    I am not sure if trying to access the column names like this is possible, instead you can try to import it with column No in to Power BI