Lookup Another Unrelated Table

[NewbieJono]

Is there a method to do a vlookup on another unrelated table. 

For example

i have a ID field and a report date, i wish to look up another table with ID and matching report date and return male / female from a gender coloumn.

[vicky_]

You can use TREATAS() (this is usually better) with the CALCULATE() function, or even just a regular FILTER() with a lot of conditions using the && operator. 

SQLBI has an article on this: https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/