Forum Discussion
Solved
Create Variables from a table
Hi, I would like to create variables from a table which relate to the row number and a specific column. There are two columns WL and ST. Each variable will be numbered in relation to Row No. As s...
Hi, PBE
You can try the following methods.
New table:
New table = ADDCOLUMNS('Table',"WL Variable","WL"&[Row No.],"ST Variable","ST"&[Row No.])Column:
Formula 1 = IF([WL Variable]="WL1"&&[ST Variable]="ST1",[ST]+[WL])Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, PBE
You can try the following methods.
New table:
New table = ADDCOLUMNS('Table',"WL Variable","WL"&[Row No.],"ST Variable","ST"&[Row No.])
Column:
Formula 1 = IF([WL Variable]="WL1"&&[ST Variable]="ST1",[ST]+[WL])
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
