Using Dax; I want to lookup a value by a date, but ignoring the day (just some moth and year) to fill a calculated column some thing like IF AND(month(table2[date]) = month(table1[date]), year(table2[date]=year(table1[date])) I will get the data