Loading Data

[Anonymous]

I have my excel data from 2012 - 2018. However, when I load the excel file, I onlly want to load those details from the year 2015. Is there any way to do this?

[Anonymous · Accepted solution]

Hey @Anonymous

When you are connecting to the Excel spreadsheet, click Edit instead of Load. This will bring you to the Power Query editor. You can then filter for only 2015. When you've done this, click Close and Apply and you will now only have 2015 data.

Hope this helps,

Parker

[Anonymous]

Hey,

This would work. Thank You!