Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to insert this column into another table

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.

 

 

 

 

  • Hi Anonymous ,

     

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

    min = related('table1'[min])
    max = related('table1'[max])

     

    Thanks,

    Samarth

2 Replies

  • Samarth_18's avatar
    Samarth_18
    Community Champion

    Hi Anonymous ,

     

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

    min = related('table1'[min])
    max = related('table1'[max])

     

    Thanks,

    Samarth