Handling new columns in a data source

[Anonymous]

Hello, 

I have a rather general question. In power BI, im using a file that is updated monthly with revenues. Every month, a new column is added to the file for the next month. Is there a way for power BI to dynamically handle these new columns? For example, if the new column for November is added and i want to make the new column part of my reverse pivot?

Thanks!

[camargos88 · Accepted solution]

@Anonymous ,

Yes, you can use the option "Unpivot other columns". 

You select the column you want to keep as is and unpivot the others....so the new dates will be unpivoted.