Compare two date columns from two different tables

[Experteam]

Hello everybody, 

I have two tables (CDE and FAC).  A order table (CDE), and an invoice table (FAC). Each with two date and ID columns. I would like to display in a visual only the ID with dates of orders (CDE) higher than the dates of FAC. Thank you

Have a good day

[tex628 · Accepted solution]

Create a calculated column in your CDE table:

Column = 
IF('CDE'[Date] > MAX('FAC'[Date])) , 'CDE'[Date] , BLANK())

Then filter on theat column <> Blank()

[Experteam]

Thank you so much