Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to compare two filtered query

Hi everyone, I'm new in the community. I need some help, I have to compare two query, in particular I filter each query by the same value and then I have to compare every row of the table 1 with eve...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 
    If we consider Table2 is the table that contains the column "INVIO", the you can ceate a new calculated column in Table1 ( The table that contains the "DATAINSERIMENTO" and "Datasuccessiva" columns) using the following code:

    INVIO =
MAXX (
    FILTER (
        Table2,
        Table2[INVIO] >= EARLIER ( Table1[DATAINSERIMENTO] )
            && Table2[INVIO] <= EARLIER ( Table1[Datasuccessiva] )
    ),
    Table2[INVIO]
)

     

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous 
If we consider Table2 is the table that contains the column "INVIO", the you can ceate a new calculated column in Table1 ( The table that contains the "DATAINSERIMENTO" and "Datasuccessiva" columns) using the following code:

INVIO =
MAXX (
    FILTER (
        Table2,
        Table2[INVIO] >= EARLIER ( Table1[DATAINSERIMENTO] )
            && Table2[INVIO] <= EARLIER ( Table1[Datasuccessiva] )
    ),
    Table2[INVIO]
)