I have a power querry with a list of clients invocies, when they where created and when is the due date for the client to pay. I want to make a dynamic table or a slicer that groups the invoices in these ranges:
Here's a starter for you. I'll let you refine it further. On Sheet1 there's a single cell A2 into which you can enter a number of days. The following FILTER formula, then, in cell C2, will list all those that exceed that number of days.