Forum Discussion

effertz12's avatar
effertz12
Icon for Helper II rankHelper II
4 years ago

Power Query to only select this months column

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 m...
Need Help
mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
4 years ago

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