cancel
Showing results for 
Search instead for 
Did you mean: 

Retrive MIN and MAX Date

KHK
Partner
Partner

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) ))

2 REPLIES 2

RADSr
Captain
Captain

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 ) 

-- IncortaOne@PMsquare.com --

anurag
Employee
Employee

This video shows how to write a formula in Incorta to get min or max date from 2 tables: