I need to return a latest date from a table but filter down on an ID
I have 2 tables
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
Any help would be appreciated.
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
Code:
=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])