I want to retrieve min date from two tables and max date from two tables.
Below is the formula. Please let me know how to achieve in Incorta.
MIN( MIN( Table1. Date), MIN(Table2.Date) ),
MAX( MAX( Table1. Date), MAX(Table2. Date) ))
Minimum and Maximum are both aggregate functions available to measures. Just drag the column into the measure area and adjust the aggregate behavior accordingly. ( you can drag the same column in more than once, set the behavior, and rename the column )