06-14-2023 06:53 AM
Hi Team,
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.
ADDCOLUMNS(
CALENDAR(
MIN( MIN( Table1. Date), MIN(Table2.Date) ),
MAX( MAX( Table1. Date), MAX(Table2. Date) ))
06-14-2023 08:17 AM
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 )
06-16-2023 10:06 AM
This video shows how to write a formula in Incorta to get min or max date from 2 tables: