Forum Discussion
Solved
Compare two date columns from two different tables
Hello everybody, :catvery-happy:
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
Create a calculated column in your CDE table:
Column = IF('CDE'[Date] > MAX('FAC'[Date])) , 'CDE'[Date] , BLANK())Then filter on theat column <> Blank()
