Suddenly filtereting is not applying anymore - no manual changes

[jaidee]

In the query editor I have duplicated my main order table to year, quarter, week, today. It has been working for a long time, but when I looked today many orders is missing. When I go to the query editor for ie. Week it only shows 10 orders. The filter on the colums is set to week.

I I make a new duplicate of the orders table and filter on the same row I get all the orders. Off course I can do then all again but I am wondering why this can happen?

= Table.SelectRows(Source, each Date.IsInCurrentWeek([date_complete]))

[jaidee · Accepted solution]

My own mistake. I had them refferenced. And then refferenced week from quarter, which gace trouble today when new quarter in the middle of a week