Want to Calculate max date from multiple date columns in Quicksight

Question & Answer
,
1

I want to find latest date from multiple date columns. Lets suppose there are 4 date columns. I want to find max date for the same.
in Excel its quite simple - take max(Date1, Date2, Date3, Date4) but not able to solve this in Quicksight.

Thanks in advance

2

Hi @krishna1995

To find the latest date from multiple date columns in Amazon QuickSight, you can use a calculated field. However, QuickSight does not directly support a MAX function across multiple columns like Excel. Instead, you’ll need to create a series of calculated fields to compare the dates. Refer the below the posts.

1 Like
3

Marking @Xclipse 's response as solution.

Regards,
Arun Santhosh
Pr QuickSight SA

1 Like