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.
Yuko_Tarby255 That's difficult to answer without looking at the date and the query itself. Since it's just a test file, you can perhaps share it via Onedrive, Dropbox are similar. Always much easier to work with a file on hand.
- Would you please take a look?
https://1drv.ms/x/s!AmXz2i0hTvTlgew0ZFxFUkEuTpGZ_w?e=NkE4Ps
