Get Max Date

[mikeymay]

I need to return a latest date from a table but filter down on an ID

I have 2 tables

• AD Visit - Holds details of visit dates and can have multiple visits for an ID
• AD Completed - Holds the ID and needs to show the latest date for an ID

The last vist date needs to work on up to the last 8 quarters so as well as filtering on the ID, I need to filter on the dats in the quarter only.

I hoped the following would work but it is returning an error stating only 2 arguments can be passed in the MAXX function

=maxx(filter('AD Visit',[Company ID]='AD Expected'[Co.No.]),filter('AD Visit',[Completed on]>=[QCStart]),filter('AD Visit',[Completed on]<=[QCEnd]),'AD Visit'[Completed on])

Any help would be appreciated.

 

[VBA Geek]

hi mikeymay, cold you show a sample dataset?

 

[mikeymay]

Unfortunately not as its NDAed....

In a very simple format it could consist of the following though as per the column descriptions in the formula
AD Visit Table
Col A - Company ID
Col B - Completed On (this is the last visit date)

AD Expected Table
Col A - Co.No.
Col B - Result of the formula

The Measures QCEnd & QCStart are basically the Quarter start and end dates