How to use values of a visual datatable in another visual datatable

[Esra90]

Hi, I have created LOOKUP visual datatable in reports by using DATATABLE on the left as my datasource. LOOKUP table contains min,max and average of column Average on DATATABLE grouped by RefId and Year of the column Date.  What I am trying to do is creating 2nd visual datatable as shown on the right and adding the red coloured columns either from LOOKUP table or by adding New Column, Measure on DATATABLE if possible.

Thanks for your help.

[djurecicK2]

You should create 3 measures based on Datatable and use them in both visuals.

MinAverage=MIN(Datatable[Average])

MaxAverage= MAX(Datatable[Average])

AvgAverage= AVERAGE(Datatable[Average])

[Esra90]

But I need these values grouped by RefId and year of column Date. How can I manage to get MinAverage, MaxAverage and AvgAverage of grouped values?