Forum Discussion
Power Query Refresh issue
Yuko_Tarby255 Sure, you can have all in one file, but In the step before you "remove other columns" you need to filter the Item column. It works similar to how you filter in Excel. Press the downward pointing triangle in the column header and define the filter you need. In this case I used "does not contain TOTAL"
By the way, I've been experimenting with PQ in Excel for the Mac when I looked at your file. In the PC version the pictures are slightly different but the principle is the same. So it will not look exactly the same on your computer.
You might find the link below useful in getting up to speed with PQ basics.
Thank you so much look into this!! I am still struggling so, I created data file and PQ file separately then it worked. However, my goal is use one spreadsheet to do all. I do understand what you explained but would you please tell me how to lock the item?(Key icon). Thank you again.
Yuko_Tarby255 Sure, you can have all in one file, but In the step before you "remove other columns" you need to filter the Item column. It works similar to how you filter in Excel. Press the downward pointing triangle in the column header and define the filter you need. In this case I used "does not contain TOTAL"
By the way, I've been experimenting with PQ in Excel for the Mac when I looked at your file. In the PC version the pictures are slightly different but the principle is the same. So it will not look exactly the same on your computer.
You might find the link below useful in getting up to speed with PQ basics.
- Hi Riny,
OMG IT WORKED!!! I could change the source data or adding another worksheet and ALL WORKED! Thank you for being patient with me. I bookmarked the link and will learn more! THANK YOU!!!