Forum Discussion

aatish178's avatar
aatish178
Icon for Helper IV rankHelper IV
2 years ago
Solved

comparing two dates from two different tables and filtering the date1 according to the condition

Hi All,

I have two tables consisting of date columns:

Table1 has Date1 column with below data:

Date1
15-01-2021
18-01-2021
20-01-2021
12-03-2023
27-03-2023
05-05-2023
10-06-2023

 

Table2 has Date2 Column with below data:

 

 

Date2
07-01-2022
08-01-2022
09-01-2022
10-01-2022
27-03-2021
05-05-2021

10-06-2020

 

There is no direct relationship between 2 tables.

Expected Result:

In table visual,

I want to show only those dates in Date1 column which are less than or equal to maximum date of Date2 column.

That means only below data:

15-01-2021
18-01-2021
20-01-2021

 

and for rest of the dates blank should be visible.

Can someone plz help with possible solution on filtering Date1 column based on MAX(Date2)

Ashish_Mathur ,quantumudit 

 

Regards,

Aatish

 

6 Replies

  • Hi,

    The maximum date on Table 2 is 10 January 2022.  None of the dates that you have shown in the expected result if less than 10 January 2022.  Recheck your post.

    • aatish178's avatar
      aatish178
      Icon for Helper IV rankHelper IV

      Hi, Thanks for noticed it out... I have modified the expected result.

      Can you please help me with possible solution 

       

      Aatish