Want to Calculate max date from multiple date columns in Quicksight

[Xclipse]

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.

Function to calculate aggregate over a range of columns, same as in excel =max(c1:c5)

Function to calculate aggregate over a range of columns, same as in excel e.g. =max(c1:c5). If this functionality already exists, please share its working.