Forum Discussion
Davidm54
Jun 17, 2021Brass Contributor
Power Query Date Filter missing dates
I am in charge of tracking a covid check-in database for my org, and I have a spreadsheet that has been working for weeks. It's now failing on 2 fronts, and I can't see why at all. The check-ins...
Davidm54
Jun 17, 2021Brass Contributor
No. Haven't seen errors. I may check that specifically, I just did a test new sheet which has worked.
I am not sure on the reason, but it seems it doesn't like not finding any data.
So if I do the date filter on the initial PQ, it seems to mess things up, but if I do the PQ from folder and just dump it into the spreadsheet then PQ that with the filter it all works.
I am not sure on the reason, but it seems it doesn't like not finding any data.
So if I do the date filter on the initial PQ, it seems to mess things up, but if I do the PQ from folder and just dump it into the spreadsheet then PQ that with the filter it all works.
SergeiBaklan
Jun 20, 2021Diamond Contributor