Forum Discussion
Solved
Lookupvalue
Hi, I want to transfer a value from one mapping table to another table using lookupvalue. This value is date-dependent (valid from and valid to) Mapping table: Target Table: The ...
Till , Not Sure I got it
you can move data from one table to another using multiple conditions like this
New Column = maxx(filter(table2,table2[Col1]= table1[col1] && table2[Col2]= table1[col2] ),table2[required_col])
Maxx can be replaced with sumx,countx etc
If you have serveral conditions, you can use && to join all of them.
Please try below measure
New Column = maxx(filter(map_inv,map_inv[value_1]= v_inv_full[Aktivität] && map_inv[value_2]= v_inv_full[Ebene]&&,v_inv_full[Datum]>=map_inv[valid_from]&&v_inv_full[Datum]<=map_inv[valid_to] ),map_inv[value_3])
