Get minimum date by year

[maxime66]

Hi,

i would like to duplicate on each line of year the min (date) in an expression  (see example)

Thanxx

[#2]

Maybe you want add something like the following to your load script?

[Data]:

LOAD date,

          year(date) as year

FROM [your\source];

[Tmp_Minimum]:

LOAD year,

          Date(Min(date), 'DD.MM.YYYY') as minimum

RESIDENT [Data]

GROUP BY year;

LEFT JOIN([Data])

LOAD year, minimum

RESIDENT [Tmp_Minimum];

DROP TABLE [Tmp_Minimum];

[maxime66]

hi Dorothea,

thanks but i don't want to modify my script ...

can't we put a calculated dimension in aggr ? like :

aggr(min(date),year(date)) (doesn't work for me)

[#4]

Hi,

try to use function

FirstSortedValue()