How to refer to a date from another table?

[Anonymous]

Hello!

I a query, I want to filter rows using the MAX date from a column in a table of another query.

Any idea how to do that? I was thinking something like MAX(Table1.Column1) but I am not sure how it is exactly.

Thanks!

[Anonymous · Accepted solution]

Hi @Anonymous ,

It's easy using DAX or Relationship. If you want to do this in Query Editor, you could refer to the following steps.

1# Sort the Date of Table2 from latest to earliest.

2# Add a custom column in Table1.

3# Add a conditional column and filter the null value.

Best Regards,

Jay

[TheoC]

Hi @Anonymous 

I believe what you are looking for is LASTDATE?  Measure = LASTDATE ( 'table'[column]).

Hope this helps.

Also, if you don't already, I'd recommend adding a Calendar / Date table (https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/) which helps keep things nice and in order 🙂  You can then create relationships between the relevant Fact tables to the Date table and maintain filtering / slicing using the Dates from the Date table to ensure consistency and alignment.

Have a good one!