A Text evaluated as an Expression in DAX

[Julia_24]

I need your expertise in solving this requirement?

I have a below 3 tables, Table contains the Measure stored as a String in backend.

How do we evaluate a String in Formula column of Table_1 as a Measure?

Table_1:

ParentID (Num)	Parent_Name	Formula (DAX Measure given as a written as a String)
1	Complex_1	= Calculate(Sum(Table_2[X]-Sum(Table_2[Y]))
2	Complex_2	=Calculate(Sum(Table_3[A] * Sum(Table_3[B]))

Table:

Date	Parent_ID	X	Y
10.11.2022	1	60	45
11.11.2022	1	85	60
12.11.2022	1	30	20
13.11.2022	1	45	12

Table_2:

Date	Parent_ID	A	B
10.11.2022	2	60	50
11.11.2022	2	80	60
12.11.2022	2	30	20
13.11.2022	2	45	12

@DAX

[parry2k]

@Julia_24 afaik it is not possible.

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo