How to insert this column into another table

[Anonymous]

I have a table, with a snippet of it shown below.

I want the min/max columns to be added to another table. Does anyone know how I can write in DAX for the corresponding min/max value for each tagname to be added to the second table, i.e. for s011_tic11_23_pv, add the min and max values 0.5 and 2.5 in the 2nd table. The 2nd table has multiple repeats for each tagname so I want the min/max to be copied in for all of the repeats.

[Samarth_18 · Accepted solution]

Hi @Anonymous ,

You can create two columns in table 2 like below:-

min = related('table1'[min])

max = related('table1'[max])

Thanks,

Samarth

[Anonymous]

Thanks @Samarth_18 , that worked