Forum Discussion

darcas2012's avatar
darcas2012
Frequent Visitor
4 years ago

compare 2 dates from different tables

Hello, I would really appreciate the help.
I have 2 tables with custom columns


I need to compare those 2 dates and get the difference in months and that I stay in Table1 I don't know if as a column or as a measure, because later I need to calculate which ones have more than 6 months to fulfill an indicator. for example:

 

General Comment
Need Help

1 Reply

  • Samarth_18's avatar
    Samarth_18
    Community Champion
    4 years ago

    Hi darcas2012 ,

     

    Create a column like below:-

     

    Column =
DATEDIFF (
    LOOKUPVALUE ( Table2[FechaRegistro], Table2[id], Table1[id] ),
    Table1[Fecha solucion],
    MONTH
)

     

    output:-

     

     

     

    Thanks,

    Samarth