Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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]))
Solved! Go to 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
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