Forum Discussion
Anonymous
4 years agoNot applicable
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_18Community Champion
Hi Anonymous ,
You can create two columns in table 2 like below:-
min = related('table1'[min])max = related('table1'[max])Thanks,
Samarth
- AnonymousNot applicable
Thanks Samarth_18 , that worked