Is Invoice Complete vs. Pending

Hey Anonymous,

I'm sorry, hopefully I'm missing something. But your file does not solve my problem. You do some cool transformations in it, and I will keep it for reference. But lets try again. :robotlol: 

It might help if I give as much context as I can. This is based on a report for invoices that have problems with them. I receive this report weekly. When a given invoice stops showing up on the invoice, it means it is closed, or completed. I am tasked with creating a dashboard that shows which invoices are open, and how long they have been open. Once they’re closed, I need to be able to count how many weeks it took for the problematic invoice to be closed.

Inv#                     Report Date                           Max Report Date                Column I want

I’ve made a small sample dataset for you. The goal is, using Columns A, B, C, create a Power Query that returns me the values in column D.

Given the context of the project, if you believe this approach is not the solution, please help explain how I should be solving this logic.

Thanks again for your help,

-DK

P.S. is there a better way for me to attach a table to a response?