Forum Discussion

vhugozg's avatar
vhugozg
Frequent Visitor
4 years ago

Filter date by last date from another table

Hi everyone,   I'm trying to filter a table related to the last date from another one. These dates can't have a direct relation, so I tried to create measures, calculated columns, and much more to ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

vhugozg , if you want to use max date from another table in a table then try

if(Table1[Date] < Max(Table2[Date]) ,1, 0)

vhugozg's avatar
vhugozg
Frequent Visitor
4 years ago

Hi amitchandak , firstly thank you for the response and help.

I tried to do exactly as you said in the column "CadastroMenorQue":

But the results always returns 0.


I don't know why this is not filtering the max date. The last column I used the same max formula you sent, but it stills show as 31/12/2022.