Download Excel File: https://excelisfun.net/files/EMT1776.xlsx
Learn extract invoice that are past due 1 to 30 days using Power Query..
Learn how to.
1. (00:00) Introduction
2. (00:26) Bring Defined Name Parameter into Power Query with number of days.
3. (01:15) In Power Query, use Filter In Previous feature to extract records 30 days back.
4. (02:38) Test query by changing number of days input from the worksheet cells and refresh query.
5. (03:23) Equation to viewers and what I think
6. (03:40) Closing and Video Links