Forum Discussion

Experteam's avatar
Experteam
Regular Visitor
7 years ago
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...
Need Help
Tutorial Requests
  • tex628's avatar
    tex628
    7 years ago

    Create a calculated column in your CDE table:

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

    Then filter on theat column <> Blank()

tex628's avatar
tex628
Community Champion
7 years ago

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's avatar
    Experteam
    Regular Visitor
    7 years ago

    Thank you so much