Is Invoice Complete vs. Pending

[Anonymous]

Hey guys,

So I am trying to show if an invoice is complete or pending for all lines it exists if it is either. 

This is based off 2 columns. Invoice number and reporting date.

Above is an example of a single invoice that is still appearing on the report. I want to have a column that for all lines reads ‘pending’ if the max report date of an invoice # is equal to the most recent report date. If it is less than the most recent report date, I want it to read "complete" for all lines. 

I have a few custom Columns I have been playing with:

Current Date = MAX('Complete & Pending'[Reporting Date ])

Complete Pending = IF('Complete & Pending'[Reporting Date ].[Date] < 'Complete & Pending'[Current Date], "Complete", "Pending")

For instance,

Since the max [Reporting Date] and the [Current Date] match for this invoice, I want the 4th column to read ‘pending’ for all the lines. Any ideas?

Thanks