topic Re: Retrive MIN and MAX Date in Dashboards & Analytics Discussions

Retrive MIN and MAX Date

KHK — Wed, 14 Jun 2023 13:53:09 GMT

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

Re: Retrive MIN and MAX Date

RADSr — Wed, 14 Jun 2023 15:17:11 GMT

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 )

Re: Retrive MIN and MAX Date

anurag — Fri, 16 Jun 2023 17:06:51 GMT

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

https://youtu.be/hCB2TVaQ1AI