Last seen: Jul 8, 2026
Not entirely sure what you intend to do but that error occurs when you try to insert a row and the Offset element is larger than the number of rows in...
OK, perhaps I misunderstood your intentions, since you posted your question in the PQ section of the forum.
But with PQ you can connect to an unsorted table and do the sorting in PQ. Your choice.
Two possible solutions (not in PQ though), provided that you sort the table by Start date, ascending. =AND(B3<>"",OR([@Start]<=N(C1),...
I see. Then I'm afraid I can't help you any further.
Sorry, I'm not aware of the ability to sort inside a Waterfall Chart (WC) like in your example. What you can do, however, is create a chart without...
You could try adding an Index column and then sort.
No, don't know how to custom sort. But isn't the whole purpose of a Waterfall Chart to display the categories in their order of significance? No exper...
You created a relationship between tables E3 and Breakdown. It seems to create a nameless extra "field" for the sum of all Categories (i.e. 914). Rem...
As a variant, this code will produce a summary by person (Name, Allowance, Leave Taken and Balance). let Source = Excel.CurrentWorkbook(){[Name="Al...
Not sure I follow and you didn't put all transactions in one table with separate columns for Qty Ordered and Qty Received. Then you can sort all trans...
Didn't you get your answer here?
I would recommend to change the set-up a bit. Have one table with three columns for the quantities (OrderedQTY, ReceivedQTY and AllocatedQTY). Then yo...
Why not use a formula similar to the CF rule for "Overdue", and its opposite for "On Time"? In J2: =SUM(--(E2:E21<=D2:D21)), returning 11 ...
As a variant. No pivot table needed. Result directly from PQ let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], Transpose = Table.Tran...