Forum Discussion
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)
Regards,
Aatish
PBI file attached.
Hope this helps.
6 Replies
- Ashish_Mathur
Super User
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
Helper IV
Hi, Thanks for noticed it out... I have modified the expected result.
Can you please help me with possible solution
Aatish
- Ashish_Mathur
Super User