Forum Discussion
Solved
Read explained formula
Hello everyone, I've this problem. I have a Table TAB1 with some columns TAB1_n, TAB1_A, TAB1_B, TAB1_C, TAB1_D, with some numerical data. I have also a Table TAB2 with these columns TAB2_n, TAB2_...
Hi Marco_88 ,
DAX cannot make this however you can do it using Power Query.Your merge table should have the following format:
Has you can see I replaced the X by the values of each line.
Now do a merge with the Tab 1 on N and expand the table A, b, C ,D
Now add the following custom column:
Expression.Evaluate( Text.Replace(Text.Replace(Text.Replace(Text.Replace([FORMULA],"A",Number.ToText([A])),"B",Number.ToText([B])),"C",Number.ToText([C])),"D",Number.ToText([D])))Now delete the columns ABC
Final result:
Hi Marco_88 ,
DAX cannot make this however you can do it using Power Query.
Your merge table should have the following format:
Has you can see I replaced the X by the values of each line.
Now do a merge with the Tab 1 on N and expand the table A, b, C ,D
Now add the following custom column:
Expression.Evaluate( Text.Replace(Text.Replace(Text.Replace(Text.Replace([FORMULA],"A",Number.ToText([A])),"B",Number.ToText([B])),"C",Number.ToText([C])),"D",Number.ToText([D])))
Now delete the columns ABC
Final result: