# Last date for a customer

• ### Question

• Hello. I used a formula to get last date from another table. Can someone explain how this works? Thanks.

=MAXX(RELATEDTABLE('Big Invoices My Baby'),'Big Invoices My Baby'[IV Created Date])

Sunday, September 18, 2016 9:14 AM

• Hi AlexMartini,

The RELATEDTETABLE function changes the context in which the data is filtered, and evaluates the expression in the new context that you specify. MAXX Function evaluates an expression for each row of a table and returns the largest numeric value. The formula will evaluates the largest numeric value of [IV Created Date] column in table 'Big Invoices My Baby' which is linked to your current table.

Regards,
Angelia
• Proposed as answer by Friday, September 23, 2016 5:51 PM
• Marked as answer by Thursday, September 29, 2016 9:03 AM
Monday, September 19, 2016 5:04 AM

### All replies

• Hello. I used a formula to get last date from another table. Can someone explain how this works? Thanks.

=MAXX(RELATEDTABLE('Big Invoices My Baby'),'Big Invoices My Baby'[IV Created Date])

• Merged by Sunday, September 18, 2016 10:48 AM Same question from same OP
Sunday, September 18, 2016 9:14 AM
• Hello. I used a formula to get last date from another table. Can someone explain how this works? Thanks.

=MAXX(RELATEDTABLE('Big Invoices My Baby'),'Big Invoices My Baby'[IV Created Date])

• Merged by Sunday, September 18, 2016 10:46 AM Same question from same OP
Sunday, September 18, 2016 9:14 AM
• Hi AlexMartini,

The RELATEDTETABLE function changes the context in which the data is filtered, and evaluates the expression in the new context that you specify. MAXX Function evaluates an expression for each row of a table and returns the largest numeric value. The formula will evaluates the largest numeric value of [IV Created Date] column in table 'Big Invoices My Baby' which is linked to your current table.