Power Query to only select this months column

[effertz12]

I Have an excel File that contains products and supply orgs and etc. which are columns that i always want to load via power query. It also includes forecasted data for each month, and these contain months actuals and future months forecasts. We drop the previous year's months in the middle of the year, so the location of the current month column changes at certain points in the year. Is there a way to dynamically only bring in the current month's column while dropping the rest. In this example below the current month is in column AX, but in July it might be located in a different column. I have created dynamic headers to pull before but those always just choose the first X number of columns. I need a query to figure out which column contains this month and pull it dynamically. 

[mussaenda]

Hi @effertz12 ,

Yes of course you can do it.

But you need to transform first your data.

You can Unpivot your columns and the change to the correct date type then filter to this month only.

If you have a sample data that we can work on, we can help you better.

Thanks

[lbendlin]

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with.